how to find out whether a view is updatable

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: how to find out whether a view is updatable
Date: 2013-06-04 15:59:07
Message-ID: 51AE0ECB.5080906@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2013-06-04 16:00:10 Re: local_preload_libraries logspam
Previous Message Peter Eisentraut 2013-06-04 15:54:52 psql \dv+ shows view size as 0 bytes