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

1 vote179 views2 answers
Sql server add time to date
SQL
10 votes341 views4 answers
Mysql if else
SQL
0 vote172 views1 answer
Psql list rules
SQL
0 vote195 views1 answer
What is top n result in sql
SQL
0 vote194 views1 answer
Postgresql regular expression special characters
SQL
0 vote152 views2 answers
Avg() sql
SQL
0 vote172 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote182 views1 answer
Mysql add root password
SQL
0 vote222 views1 answer
Pl sql round
SQL
2 votes179 views1 answer
Wait delay in sql server
SQL