Re: Comment for column in view - "legal" or just working? - Mailing list pgsql-general

From Dave Page
Subject Re: Comment for column in view - "legal" or just working?
Date
Msg-id 46B984B2.4020403@postgresql.org
Whole thread Raw
In response to Comment for column in view - "legal" or just working?  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
Responses Re: Comment for column in view - "legal" or just working?  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: backend process terminates
Next
From: "Harald Armin Massa"
Date:
Subject: Re: Comment for column in view - "legal" or just working?