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

9 votes119 views3 answers
Oracle undo usage by session
SQL
0 vote131 views1 answer
Mariadb maximum left join
SQL
1 vote135 views3 answers
How to pass password to mysql command line
SQL
1 vote124 views1 answer
Oracle drop job if exists
SQL
0 vote121 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote122 views4 answers
Sql server date format yyyy-mm-dd
SQL
-1 vote163 views1 answer
Difference berween database and data base management system
SQL
6 votes119 views5 answers
Alter table oracle
SQL
6 votes112 views2 answers
Drop foreign key
SQL
0 vote105 views1 answer
Sql replace id with name from another table
SQL