Re: Can I COPY a VIEW to a File - Mailing list pgsql-novice

Kumar S wrote:
 > Hi Group,
 >  I want to copy a view to a output file.
 >
 > => copy test_uniqueprobeset to
 > '/temp/test_uniqueprobeset_focus';
 > ERROR:  cannot copy from view
 > "test_uniqueprobeset_focus"
 >
 > 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.

Best regards
   Oliver

--
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