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

3 votes198 views1 answer
Async await mysql nodejs
SQL
1 vote303 views1 answer
Aqua Data studio postgresql ssl
SQL
17 votes191 views3 answers
Cast in sql server
SQL
0 vote268 views1 answer
Sqlite schema structure of a relational database
SQL
13 votes274 views2 answers
Sqlite rename table
SQL
0 vote193 views1 answer
Primary key multiple colums
SQL
12 votes190 views4 answers
How to take database dump in postgresql
SQL
0 vote192 views1 answer
Null column as zero in mysql
SQL
3 votes198 views3 answers
Stop mysql service ubuntu
SQL
1 vote217 views2 answers
Sql queries practice
SQL