> >>> 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. > > Not to be a sour apple or anything but I don't see how any of this is > needed in the backend since we can easily use Psql to do it, or pretty > much any other tool.
There is an important difference between a capability in the backend vs one synthesized in the frontend. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings