Обсуждение: Comment for column in view - "legal" or just working?

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 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 :) )

My question is:

- is this a legal usage of COMMENT, or could this "vanish" in later releases?
 (within COMMENTs documentation there is only mentioned    column <tablename>.<columname>)


Best wishes,

Harald


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

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

Thanks, Dave.

<---- reminds me to run allways newest pgadmin, even on customer sites :)

having it used within pgadmin makes it "legal" enough for me to rely on it within my application

Best wishes,

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!