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

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

CREATE OR REPLACE FUNCTION copyData()   RETURNS boolean AS $BODY$ DECLARE i int; begin     i :=1; FOR i IN 1..9 LOOP copy 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;

执行下面命令，运行函数

?

1	SELECT *from copyData();

执行结果：

?

1 2 3 4 5 6 7 8 9 10

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