Re: COPY view

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: COPY view
Дата
Msg-id 200606142111.k5ELBpk22349@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: COPY view  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-patches
Andrew Dunstan wrote:
> >Right, but even when we have that, should we be able to dump a view just
> >like a real table?
> >
> >
> >
>
> Wouldn't it just be this? :
>
>   COPY (SELECT * from viewname) TO ...
>
> I don't see why views should be special. Tables clearly should be
> because we can open them directly.

Ah, I didn't think of that.  Good idea.  So we don't need this patch?

--
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: COPY view
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] Fix Ctrl-C related issues in psql (not for 8.1)