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:
where x.id = new.id
how do I get copy to do this (simple example, I know)?
In response to
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2007-08-21 16:21:03|
|Subject: Re: How to export query results|
|Previous:||From: Tena Sakai||Date: 2007-08-21 15:48:16|
|Subject: Re: After adjusting checkpoint related entries in postgresql.conf... |