PostgreSQL使用存储过程添加批量插入测试数据

create or replace function creatData2() returnsboolean AS$BODY$declare ii integer;beginII:=1;FOR ii IN 1..500LOOPINSERT INTO t01_author (id, name, gender, country) VALUES (ii,'测试','F', 'china');end lo

神秘嘉宾吴彦祖

977人浏览 · 2020-05-12 15:17:09

神秘嘉宾吴彦祖 · 2020-05-12 15:17:09 发布

create or replace function creatData2() returns 
boolean AS
$BODY$
declare ii integer;
  begin
  II:=1;
  FOR ii IN 1..500	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;

插入500条数据，存储过程是比较简单的添加数据的方法