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
