Re: creating a dumpfile from a view - Mailing list pgsql-general

From Michael Fuhr
Subject Re: creating a dumpfile from a view
Date
Msg-id 20061031033742.GA13279@winnie.fuhr.org
Whole thread Raw
In response to Re: creating a dumpfile from a view  ("Taras Kopets" <tkopets@gmail.com>)
List pgsql-general
On Tue, Oct 31, 2006 at 02:38:27AM +0200, Taras Kopets wrote:
> Richard Yen wrote:
>
> >Would anyone know how to dump the data from the view?
>
> You should check COPY command in the manual:
> http://www.postgresql.org/docs/current/static/sql-copy.html to save all your
> data.
> But you have to use tables with copy, not views.

That'll change in 8.2.  Here's an item from the Release Notes:

* COPY TO can copy the output of an arbitrary SELECT statement

--
Michael Fuhr

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: postgresql books and convertion utilities
Next
From: Richard Broersma Jr
Date:
Subject: Re: Bad performance in bulky updates