Andrew Dunstan wrote:
> Mark Woodward wrote:
>> Tom had posted a question about file compression with copy. I thought
>> about it, and I want to through this out and see if anyone things it is a
>> good idea.
>> Currently, the COPY command only copies a table, what if it could operate
>> with a query, as:
>> COPY (select * from mytable where foo='bar') as BAR TO stdout
> Isn't this already being worked on? The TODO list says:
> Allow COPY to output from views
> Another idea would be to allow actual SELECT statements in a COPY.
> Personally I strongly favor the second option as being more flexible
> than the first.
I second that - allowing arbitrary SELECT statements as a COPY source
seems much more powerful and flexible than just supporting COPY FROM VIEW.
In response to
pgsql-hackers by date
|Next:||From: Andrew Dunstan||Date: 2006-06-02 14:29:42|
|Subject: Re: 'CVS-Unknown' buildfarm failures?|
|Previous:||From: Mark Woodward||Date: 2006-06-02 14:23:30|
|Subject: Re: COPY (query) TO file|