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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
