Re: is there a reason we can't copy from a view?

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: is there a reason we can't copy from a view?
Дата
Msg-id
3724.1285275595@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
is there a reason we can't copy from a view? Josh Berkus <josh@agliodbs.com>
Re: is there a reason we can't copy from a view? Tom Lane <tgl@sss.pgh.pa.us>
Josh Berkus  writes:
> ... other than it just got forgotten?

We've been over that ground before.  IIRC the conclusion was that
letting COPY TO pretend that a view is a table is a bad idea because
then people would complain about COPY FROM not working for it.  You
can useCOPY (select * from myview) TO ...
so the functionality is available.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Josh Berkus
Дата:
От: David E. Wheeler
Дата:
FAQ