Postgres Pro
Downloads
Home   >   mailing lists

Re: how to find out whether a view is updatable - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: how to find out whether a view is updatable
Date
Msg-id CAB7nPqQnkDxcn5ByjddZ-wKJCdCNDeT8rKP9gK-=nV7LpqYsgg@mail.gmail.com
Whole thread Raw
In response to how to find out whether a view is updatable  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: how to find out whether a view is updatable
List pgsql-hackers
Tree view



On Wed, Jun 5, 2013 at 12:59 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
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?
Just by recalling the thread, an oversight. Having this information in ¥dv+ would
be indeed a nice addition.
--
Michael

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Improved error message for CREATE EXTENSION patch...
Next
From: amul sul
Date:
Subject: Re: create a git symbolic-ref for REL9_3_STABLE