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

Re: COPY (query) TO file

From: David Fetter <david(at)fetter(dot)org>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Mark Woodward <pgsql(at)mohawksoft(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: COPY (query) TO file
Date: 2006-06-02 21:34:48
Message-ID: 20060602213448.GB23684@fetter.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Fri, Jun 02, 2006 at 09:56:07AM -0400, Andrew Dunstan wrote:
> Mark Woodward wrote:
> >Tom had posted a question about file compression with copy. I thought
> >about it, and I want to through this out and see if anyone things it is a
> >good idea.
> >
> >Currently, the COPY command only copies a table, what if it could operate
> >with a query, as:
> >
> >COPY (select * from mytable where foo='bar') as BAR TO stdout
> >
> >  
> 
> Isn't this already being worked on? The TODO list says:
> 
>  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.

+1 :)

Cheers,
D
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!

In response to

pgsql-hackers by date

Next:From: Greg StarkDate: 2006-06-02 21:41:07
Subject: Re: More thoughts about planner's cost estimates
Previous:From: Tino WildenhainDate: 2006-06-02 21:29:48
Subject: Re: COPY (query) TO file

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