Re: how to find out whether a view is updatable

On 6/19/13 11:50 AM, Dean Rasheed wrote:
> On 19 June 2013 15:22, Peter Eisentraut <peter_e@gmx.net> wrote:
>> We still don't have any support for this in psql, do we?
>>
> 
> No, but at least we now have an API that psql can use.
> 
> There are still a number of questions about the best way to display it in psql.
> Should it be another column in \d+'s list of relations?
> Should it appear in \d+ for a single relation?
> Should it distinguish updatable from insertable and deletable?
> Should tab-completion also be modified?
> 
> Currently I'm thinking yes, yes, no, yes.

I would be satisfied with no, yes, no, no.  Although I don't know what
tab completion changes you have in mind.