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 vote247 views1 answer
Helptext in sql
SQL
0 vote244 views1 answer
Dbms_output sql developer
SQL
1 vote239 views1 answer
Events mysql
SQL
0 vote224 views1 answer
How to find top 3 salary in sql
SQL
0 vote269 views2 answers
How to get max from each department in sql
SQL
0 vote241 views1 answer
Stored function in sql
SQL
1 vote247 views1 answer
Hackerrank sql test solutions
SQL
0 vote224 views1 answer
Like and not like together in sql
SQL
0 vote243 views1 answer
Is not sql
SQL
5 votes285 views3 answers
Create function in postgresql
SQL