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

10 votes163 views1 answer
Oracle dependencies table
SQL
2 votes140 views2 answers
Compare date mysql
SQL
1 vote168 views1 answer
Mysql curdate between two dates
SQL
0 vote143 views1 answer
Oracle list subpartitions
SQL
0 vote150 views1 answer
Database xml sql
SQL
0 vote165 views1 answer
Compare if is null sql
SQL
1 vote153 views1 answer
Oracle duration between timestamps
SQL
0 vote155 views2 answers
Sql server set default value equal to auto increment
SQL
2 votes164 views1 answer
Oracle percentage
SQL
0 vote158 views1 answer
T-SQL Never ending DELETE
SQL