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条数据,存储过程是比较简单的添加数据的方法