参考:https://www.pianshen.com/article/6204134526/
创建表:
CREATE TABLE t_test(
ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL
);
模拟批量插入:
insert into t_test SELECT generate_series(1,5000000) as key,repeat( chr(int4(random()*26)+65),4), (random()*(6^2))::integer,null,(random()*(10^4))::integer;
解释:
其中:
1、generate_series(1,5000000),表示生成一个数值序列,从1到5000000,步进为一。
generate_series作用可见下表:
注:表来源
<