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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
