Postgresql 随机生成测试数据sql

100w条随机测试数据。

create table abc (a integer,b integer,c integer ,d integer);postgres=# insert into abc select (random()*(10^5))::integer,(random()*(10^5))::integer,(random()*(10^5))::integer from generate_series(1,1000000) ;INSERT 0 1000000

测试数据

1000条自定义范围的测试数据:a[1,100]b[1,10]c(3001,4000)insert into abc select (random()*(100-1)+1)::integer,(random()*(10-1)+1)::integer,generate_series(3001,4000);

By 狮子歌歌