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)?
Thanks,
Chris
PG 8.1