Answers for "generate random seed data psql"

SQL
1

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)
Posted by: Guest on August-25-2021
1

psql seed database

psql < your_test_database.sql
Posted by: Guest on September-03-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language