Re: Copy command to handle view for my export requirement

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: Copy command to handle view for my export requirement
Дата
Msg-id 20110811085306.GA16186@tux
обсуждение исходный текст
Ответ на Copy command to handle view for my export requirement  (Siva Palanisamy <siva_p@hcl.com>)
Ответы Re: Copy command to handle view for my export requirement  (Siva Palanisamy <siva_p@hcl.com>)
Список 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°

В списке pgsql-general по дате отправления:

Предыдущее
От: Siva Palanisamy
Дата:
Сообщение: Copy command to handle view for my export requirement
Следующее
От: djé djé
Дата:
Сообщение: Re: already gerald2545