postgresql使用存储过程批量插入数据

create or replace function creatData2() returnsboolean AS$BODY$declare ii integer;beginII:=1;//插入两万条FOR ii IN 0..20000 LOOP//插入语句INSERT INTO t01_author (id, name, gender, country) VALUES (ii,'测试','F',

神秘嘉宾吴彦祖

2190人浏览 · 2020-11-26 14:02:47

神秘嘉宾吴彦祖 · 2020-11-26 14:02:47 发布

create or replace function creatData2() returns 
boolean AS
$BODY$
declare ii integer;
  begin
  II:=1;
  //插入两万条
  FOR ii IN 0..20000 LOOP
  //插入语句
  INSERT INTO t01_author (id, name, gender, country) VALUES (ii,'测试','F', 'china');
  end loop;
  return true;
  end;
$BODY$
LANGUAGE plpgsql;
select * from creatData2() as tab;