On 8/21/07, Chris Hoover <revoohc(at)gmail(dot)com> wrote:
> On 8/21/07, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> > Yes. you need to use the copy command inside a function and use
> > security definer to say that the function runs as a superuser.
> Ok, I thought from the documentation that copy could only extract entire
> table or a specific column.
> If I want to extract this:
> select x.name,x.create_date
> from x
> where x.id = new.id
> how do I get copy to do this (simple example, I know)?
Well, there are a couple of ways to approach this. One is to select
it into a temp table and then copy that to a file. Another would be
to use an untrusted pl language (plperlu etc...) to do it.
In response to
pgsql-admin by date
|Next:||From: Medi Montaseri||Date: 2007-08-21 17:16:12|
|Subject: ROI on 7.2 to 8.2|
|Previous:||From: Chris Hoover||Date: 2007-08-21 16:09:41|
|Subject: Re: How to export query results|