Re: COPY (query) TO file

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