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
