CREATE OR REPLACE FUNCTION insert_xxx_table(iAccountNum integer) RETURNS void AS $$
DECLARE
iCnt integer;
BEGIN
DELETE FROM xxx_table;
FOR iCnt IN 1..iAccountNum LOOP
INSERT INTO xxx_table(id,name,flag,registertime)
VALUES(lpad(iCnt::text,32,'0'),'name'||lpad(iCnt::text,4,'0'),TRUE,current_timestamp);
RAISE NOTICE 'insert_xxx_table %', iCnt;
END LOOP;
END;
$$ language 'plpgsql';
调用
SELECT insert_xxx_table(10);