Postgres Pro
Downloads
Home   >   mailing lists

Thread: Can I COPY a VIEW to a File

Can I COPY a VIEW to a File

From
Kumar S
Date:
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

Re: Can I COPY a VIEW to a File

From
Oliver Fromme
Date:
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

Re: Can I COPY a VIEW to a File

From
Kumar S
Date:
Thank you Oliver.
It worked.

-Kumar.


--- Oliver Fromme <olli@lurza.secnetix.de> wrote:

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





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