[GENERAL] Comment for column in view - "legal" or just working?

[Harald Armin Massa]

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 mentionedcolumn
.)


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!

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

[Dave Page]

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

---(end of broadcast)---
TIP 6: explain analyze is your friend

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

[Harald Armin Massa]

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
>
>
> 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.





-- 
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!