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;