Re: creating a dumpfile from a view - Mailing 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