Re: Copy command to handle view for my export requirement - Mailing list pgsql-general

Siva Palanisamy <siva_p@hcl.com> wrote:

> Hi All,
>
>
>
> I understand that copy and \copy commands in PostgreSQL work only for tables. I
> want it to export the data from varies tables. Instead, I can create a view for
> the list of tables. Can the copy or \copy commands be utilized to operate on
> views directly? Please let me know on this.

Sure, you can do that (with recent versions) with:

copy (select * from your_view) to ...


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°