Neil Conway wrote: > On Fri, 2006-06-02 at 09:56 -0400, Andrew Dunstan wrote: > > Allow COPY to output from views > > FYI, there is a patch for this floating around -- I believe it was > posted to -patches a few months back.
I have it. The pieces of it than I can use to implement the idea below, I'll try to rescue. I don't think it's that much though. > > 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. Sounds like a plan. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq