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