Generate random data postgresql

insert into towns (
    code, article, name, department
)
select
    left(md5(i::text), 10),
    md5(random()::text),
    md5(random()::text),
    left(md5(random()::text), 4)
from generate_series(1, 1000000) s(i)

Source: stackoverflow.com

Similar codes

0 vote229 views1 answer
To_date sql
SQL
0 vote206 views1 answer
Mysql group rows with same value
SQL
2 votes231 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote227 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
3 votes228 views1 answer
Oracle transaction commit rollback example
SQL
0 vote174 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote234 views1 answer
Postgres can integer fields be negative
SQL
4 votes227 views1 answer
W3schools create table
SQL
0 vote220 views1 answer
Monthly Birthday SQL Query
SQL
0 vote212 views1 answer
Sql query interview questions githu
SQL