RE: [GENERAL] Comments on columns?

From: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
To: "'Bruce Momjian'" <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: RE: [GENERAL] Comments on columns?
Date: 1999-03-12 17:36:08
Message-ID: 93C04F1F5173D211A27900105AA8FCFC145277@lambic.prevuenet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I did that and it works great. I would like \dd tablename to show the table
comment and its column comments.

-----Original Message-----
From: Bruce Momjian [SMTP:maillist(at)candle(dot)pha(dot)pa(dot)us]
Sent: Friday, March 12, 1999 7:43 AM
To: Michael Davis
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Comments on columns?

> Are there any plans to have psql support comments on columns? For
example,
> I would like to be able to add a comment on a column of a table
and have \dd
> display the table comment in addition to any/all column comments.

Find the oid of the column in pg_attribute, and insert into
pg_description.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania
19026

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 1999-03-12 18:30:37 Re: [GENERAL] Comments on columns?
Previous Message Bruce Momjian 1999-03-12 14:42:44 Re: [GENERAL] Comments on columns?