Create sample 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 vote323 views1 answer
Groupby error in mysql
SQL
0 vote325 views1 answer
How to get initials in sql
SQL
0 vote302 views1 answer
Metada in sql
SQL
5 votes321 views1 answer
Mysql get last day of month
SQL
0 vote378 views1 answer
Create table using the clause with as
SQL
5 votes337 views1 answer
Oracle list functions
SQL
0 vote337 views1 answer
When mysql server would not work in xampp
SQL
0 vote351 views1 answer
In query in sql
SQL
3 votes379 views2 answers
Savepoint in sql
SQL
13 votes328 views6 answers
Restart postgresql
SQL