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. Stefan ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
