On 8/21/07,
Scott Marlowe <
scott.marlowe@gmail.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
