Automate copy - Postgres 9.2

COPY 
(
SELECT * FROM backup_table WHERE id = 1112 AND status = 1
) 
TO '/var/lib/pgsql/1112.sql';

COPY 
(
SELECT * FROM backup_table WHERE id = 1113 AND status = 1
) 
TO '/var/lib/pgsql/1113.sql';

COPY 
(
SELECT * FROM backup_table WHERE id = 1114 AND status = 1
) 
TO '/var/lib/pgsql/1114.sql';

CREATE or REPLACE FUNCTION dump(integer)

RETURNS integer AS $$

declare

   crtRow record;

begin

      FOR crtRow in execute 'select account_id from backup_table WHERE migrated = 1 AND account_id = '|| $1

      LOOP

    COPY

        (SELECT * FROM gorfs.WBP_4868_backup_table_BLOBS WHERE migrated = 1 AND account_id = crtRow.account_id)

    TO '/var/lib/pgsql/gorfs_backup/%s.sql';

    end loop;

    return integer;

end

$$ language 'plpgsql';