how to find out whether a view is updatable

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема how to find out whether a view is updatable
Дата
Msg-id 51AE0ECB.5080906@gmx.net
обсуждение исходный текст
Ответы Re: how to find out whether a view is updatable  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
I was looking for a way in which the average psql user could learn
whether a view is updatable.  I was expecting something in \d, \d+, \dv,
\dv+, or a NOTICE from CREATE VIEW.  So far, the only way appears to be
through the information schema or the underlying pg_view_is_updatable
function.  Not even pg_views shows anything.  Is this intentional or an
oversight?



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: psql \dv+ shows view size as 0 bytes
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: local_preload_libraries logspam