From: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Automate copy - Postgres 9.2 |
Date: | 2016-06-09 02:04:14 |
Message-ID: | CAJNY3itakktmm7374_iS1ZUjMo9hhtYXZkgiw8cPOF+izSSJcg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2016-06-09 13:58 GMT+12:00 John R Pierce <pierce(at)hogranch(dot)com>:
> On 6/8/2016 6:47 PM, Patrick B wrote:
>
>>
>> 21 is the number of IDS that I wanna perform that COPY command....
>>
>
> that didn't answer my question. if you call your function like SELECT
> myfunction(21); as you showed, where are those 21 ID's coming from?
>
I don't know what u need, mate:
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';
Isn't this what u wanna know?
select DISTINCT(account_id) from backup_table WHERE migrated = 1
From | Date | Subject | |
---|---|---|---|
Next Message | Bryan Henderson | 2016-06-09 02:39:30 | Re: Why threads every 30 seconds? |
Previous Message | John R Pierce | 2016-06-09 01:58:35 | Re: Automate copy - Postgres 9.2 |