[EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb:
> Hi, I'm trying to create a dumpfile for a client. The data is gathered
> from about 7 tables, and I need to output all the columns as the client
> wishes.
>
> I figure the best way to this is to collect data from multiple tables
> and putting them
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 u
On Mon, 2006-10-30 at 16:02 -0800, Richard Yen wrote:
Hi, I'm trying to create a dumpfile for a client. The data is
gathered from about 7 tables, and I need to output all the columns as
the client wishes.
[snip]
Would anyone know how to dump the data from the view? I tried the
fol
Hi!
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.
Probably the solution will be to store al
