编写数据库函数执行循环copy命令导入大数据

CREATE OR REPLACE FUNCTION copyData()  RETURNS boolean AS$BODY$DECLAREi int;begin     i :=1; FOR i IN 1..9 LOOPcopy tb4_20130109012 to '/mnt/ramfs/weibo.tb4001w'; copy tb4_20130109012 from '/mnt/ramfs/weibo.tb4001w'; RAISE NOTICE 'i IS %', i;END LOOP;if i >1 then      return true;   else      return false;    end if; end;    $BODY$language plpgsql;

执行下面命令，运行函数

SELECT *from copyData();

执行结果：

postgres=# SELECT *from copyData();NOTICE:  i IS 1NOTICE:  i IS 2NOTICE:  i IS 3NOTICE:  i IS 4NOTICE:  i IS 5NOTICE:  i IS 6NOTICE:  i IS 7NOTICE:  i IS 8NOTICE:  i IS 9