Re: COPY (query) TO file

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
> 
> I have no idea if it is doable, but I can see uses for replication

I doubt it be really usefull (apart from maybe saving some work
coding a client app) but did you actually test it with

create table as select ...; followed by a copy of that table
if it really is faster then just the usual select & fetch?

Regards
Tino