Kumar S wrote:
> Hi Group,
> I want to copy a view to a output file.
> => copy test_uniqueprobeset to
> ERROR: cannot copy from view
> Is there are wat to capture content of the view.
I would suggest you SELECT the view INTO a temporary table,
then COPY that table. See the SQL reference manual on the
"SELECT INTO" command.
Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.
"That's what I love about GUIs: They make simple tasks easier,
and complex tasks impossible."
-- John William Chambless
In response to
pgsql-novice by date
|Next:||From: Kumar S||Date: 2004-09-24 16:49:10|
|Subject: Re: Can I COPY a VIEW to a File|
|Previous:||From: Kumar S||Date: 2004-09-24 16:11:09|
|Subject: Can I COPY a VIEW to a File|