Re: Automate copy - Postgres 9.2

On 06/13/2016 02:42 PM, Patrick B wrote:
> Hi guys,
>
> I created this function:
>
>             CREATE or REPLACE FUNCTION function(account_id integer)
>
>             RETURNS void AS $$
>
>             begin
>
>             execute 'COPY
>
>             (
>
>             SELECT * FROM backup_table WHERE account_id = ' ||
>             account_id || 'AND status = 1
>
>             )
>
>             TO ''/var/lib/pgsql/'||account_id||'.sql''';
>
>             end
>
>             $$ language 'plpgsql';
>
>
>
> The function works fine.. but is not what I need, actually.
> The function above works by calling it specifying the account_id. For
> example:
>
> You want to copy ( backup ) for the account_id number 63742:
>
>     select function(63742);
>
>
> *What I need is:*
>
> When calling the function, I have to specify the limit of account_ids to
> be copied. For example:
> To perform the commands in the function to 40 different account_ids:
>
>     select function (40);
>
>
>
> How can I do that? I can't...

I believe this has been asked and answered, namely there needs to be
further information on how you want to determine the account ids to be
selected.

>
> Cheers
> Patrick


--
Adrian Klaver
adrian.klaver@aklaver.com