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

9 votes149 views6 answers
Check constraint in sql
SQL
-1 vote137 views1 answer
Concat two columns in sql server
SQL
0 vote137 views2 answers
Import .sql into postgres db command
SQL
0 vote128 views1 answer
How to reset AI in sql
SQL
0 vote133 views1 answer
Sql server remove enter from string
SQL
2 votes144 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
3 votes252 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote153 views1 answer
Selecting all columns from table sql database
SQL
25 votes134 views3 answers
How to use a database to see tables mysql
SQL
3 votes158 views2 answers
How to modify rows in SQL Server
SQL