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 vote140 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote144 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote132 views1 answer
Intellij mysql set timezone
SQL
0 vote130 views3 answers
Sql all columns
SQL
0 vote128 views1 answer
Create table if not exist with exceptions
SQL
13 votes135 views3 answers
Insert mysql ifile nto database
SQL
0 vote130 views1 answer
How to insert a uniqueidentifier in sql
SQL
11 votes125 views1 answer
Oracle view ddl
SQL
2 votes206 views1 answer
Postgresql group by month and year
SQL
0 vote132 views1 answer
Postgres copy command
SQL