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

From: Dave Page <dpage(at)postgresql(dot)org>
To: Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Comment for column in view - "legal" or just working?
Date: 2007-08-08 08:54:10
Message-ID: 46B984B2.4020403@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harald Armin Massa 2007-08-08 09:01:27 Re: Comment for column in view - "legal" or just working?
Previous Message Martijn van Oosterhout 2007-08-08 08:47:13 Re: backend process terminates