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

11 votes147 views1 answer
Mysql text type max length
SQL
0 vote166 views2 answers
How to type a blank discord messgae
SQL
0 vote151 views1 answer
Querry mysql by 2 columns
SQL
3 votes144 views3 answers
Mysql select table names
SQL
1 vote159 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
1 vote151 views1 answer
Postgres convert exisiting column to text
SQL
0 vote149 views1 answer
Postgres sequence name
SQL
0 vote108 views1 answer
Mysql collation for all languages
SQL
0 vote144 views1 answer
Inserted row count tsql
SQL
5 votes146 views1 answer
Mysql count lines
SQL