Re: Automate copy - Postgres 9.2

CREATE or REPLACE FUNCTION function(integer)

RETURNS void AS $$

declare

   crtRow record;

begin

      FOR crtRow in EXECUTE 'select DISTINCT(account_id) from backup_table WHERE migrated = 1 AND account_id IN '|| $1

      LOOP

    COPY

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

    TO '/var/lib/pgsql/' || crtrow.account_id || '.csv';

    end loop;

end

$$ language 'plpgsql';