SQL

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)

postgresql random phone number

SELECT '('
    || (RANDOM() * 9)::INT
    || (RANDOM() * 9)::INT
    || (RANDOM() * 9)::INT
    || ') '
    || (RANDOM() * 9)::INT
    || (RANDOM() * 9)::INT
    || (RANDOM() * 9)::INT
    || '-'
    || (RANDOM() * 9)::INT
    || (RANDOM() * 9)::INT
    || (RANDOM() * 9)::INT
    || (RANDOM() * 9)::INT;