Re: COPY (query) TO file

On Fri, Jun 02, 2006 at 09:56:07AM -0400, 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.

+1 :)

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!