Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject how to find out whether a view is updatable
Date
Msg-id 51AE0ECB.5080906@gmx.net
Whole thread Raw
Responses Re: how to find out whether a view is updatable
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: psql \dv+ shows view size as 0 bytes
Next
From: Peter Geoghegan
Date:
Subject: Re: local_preload_libraries logspam