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;

SELECT *from copyData();

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