On 8/21/07, Scott Marlowe <[EMAIL PROTECTED]> 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