Re: How to export query results

On 8/21/07, Scott Marlowe <scott.marlowe@gmail.com> wrote:

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