Re: how to find out whether a view is updatable

On 19 June 2013 18:12, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> On 6/19/13 11:50 AM, Dean Rasheed wrote:
>> On 19 June 2013 15:22, Peter Eisentraut <peter_e(at)gmx(dot)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.
>

Here's a patch that does that for foreign tables and views. It regards
"updatable" as support for *any* of the DML operations. Bernd Helmle
has written a patch for tab completion.

Regards,
Dean