Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: creating a dumpfile from a view
- From: Michael Fuhr <mike(at)fuhr(dot)org>
- To: Taras Kopets <tkopets(at)gmail(dot)com>
- Cc: Richard Yen <dba(at)richyen(dot)com>, pgsql-general(at)postgresql(dot)org
- Subject: Re: creating a dumpfile from a view
- Date: Mon, 30 Oct 2006 20:37:42 -0700
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
- References:
- creating a dumpfile from a view
- From: Richard Yen
- Re: creating a dumpfile from a view
- From: Taras Kopets
- creating a dumpfile from a view
- Prev by Date: Re: postgresql books and convertion utilities
- Next by Date: Re: Bad performance in bulky updates
- Previous by thread: Re: creating a dumpfile from a view
- Next by thread: Re: creating a dumpfile from a view
- Indexes: