Re: Can I COPY a VIEW to a File

Thank you Oliver.
It worked.

-Kumar.

--- Oliver Fromme <olli(at)lurza(dot)secnetix(dot)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 Mnchen
> 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