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 vote103 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote55 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote109 views1 answer
Declare or use variable in snowflake
SQL
0 vote109 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote119 views1 answer
Insert value in identity
SQL
0 vote104 views1 answer
Sql server select record with max id
SQL
3 votes103 views2 answers
Sql server current date without time
SQL
0 vote111 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
4 votes107 views1 answer
Oracle show errors
SQL
0 vote99 views1 answer
Postgresql interview questions
SQL