Can I COPY a VIEW to a File

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Can I COPY a VIEW to a File
Date: 2004-09-24 16:11:09
Message-ID: 20040924161109.29737.qmail@web51409.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Fromme 2004-09-24 16:26:02 Re: Can I COPY a VIEW to a File
Previous Message Christian Armeanu 2004-09-23 00:12:19 Using PERFORM in plpgsql throws compile errors