参考官方文档create or replace function creatData2() returns boolean AS$BODY$declare ii integer; begin II:=1; FOR ii IN 1..10000000 LOOP INSERT INTO ipm_model_history_data (res_model, res_id) VALUES (116, ii); end loop; return true..
创建表：CREATE TABLE t_test(ID INT PRIMARY KEY NOT NULL,NAMETEXTNOT NULL,AGEINT NOT NULL,ADDRESSCHAR(50),SALARY REAL);模拟批量插入：insert into t_test SELECT generate_series(1,5000000) as key,repeat( chr(int4(random()*26)+65),4), ..
第一种:begininsert into tableName(column1, column2, column3...) values(value1,value2,value3...);insert into tableName(column1, column2, column3...) values(value1,value2,value3...);insert into tableName(column1, column2, column3.....
