Re: Comment for column in view - "legal" or just working?

Harald Armin Massa wrote:
> Using PostgreSQL 8.1.8 on Windows.
>
> I have one named listedi in schema cust; that view has one column "name"
>
> No I used
>
> comment on cust.listedi.name <http://cust.listedi.name> is
> 'MyDescriptive Name';
>
> and the command suceeded. Using \d+ in psql also shows me that comment
> (also I find no option within pgadmin to view it :) )

You can in 1.8 - that will show a collection of columns under a view,
and allow you to set the comment and default value for each.

Regards, Dave