Hi guys,
I need to do a file backup for each account_id.
Example:
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';
Can I create a PLPGSQL function to perform that?
I tried but isn't working... don't know how to determinate that:
CREATE or REPLACE FUNCTION dump(integer)
FOR crtRow in execute 'select account_id from backup_table WHERE migrated = 1 AND account_id = '|| $1
(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';
- Each account_Id would have a file with its ID
- When calling the function, I want to specify the numbers of account_Ids I wanna do the dump
Can anybody give me a help here please?