generate random data postgresql

Solutions on MaxInterview for generate random data postgresql by the best coders in the world

showing results for - "generate random data postgresql"
Yael
22 Oct 2019
1insert into towns (
2    code, article, name, department
3)
4select
5    left(md5(i::text), 10),
6    md5(random()::text),
7    md5(random()::text),
8    left(md5(random()::text), 4)
9from generate_series(1, 1000000) s(i)
10