Skip site navigation (1) Skip section navigation (2)

Re: COPY (query) TO file

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>,Mark Woodward <pgsql(at)mohawksoft(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: COPY (query) TO file
Date: 2006-06-02 16:28:53
Message-ID: 20060602162852.GF27317@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

pgsql-hackers by date

Next:From: Greg StarkDate: 2006-06-02 17:08:13
Subject: Re: More thoughts about planner's cost estimates
Previous:From: Neil ConwayDate: 2006-06-02 16:22:46
Subject: Re: COPY (query) TO file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group