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