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.

Please help.

thanks
Kumar

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Kumar S wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Thank you Oliver.
It worked.

-Kumar.


--- Oliver Fromme <olli (AT) lurza (DOT) secnetix.de> wrote:





__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly