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

From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Comment for column in view - "legal" or just working?
Date: 2007-08-08 08:31:47
Message-ID: 7be3f35d0708080131m32a7f78au6f9f211b1564fef0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-08-08 08:47:13 Re: backend process terminates
Previous Message Gregory Williamson 2007-08-07 23:59:18 Re: List tables in load order