how to see column comments?

From: "Norman J(dot) Clarke" <norman(at)combimatrix(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to see column comments?
Date: 2001-02-16 01:24:19
Message-ID: Pine.LNX.4.21.0102151721090.9324-100000@curly.combimatrix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have not been able to get psql to show column comments in version
7.1beta4. Am I doing anything wrong, or is this a bug? A transcript of my
psql session is below.

Norm

------------------------------------------------------------------

norman=# create table test_table (col1 integer);

CREATE

norman=# comment on table test_table is 'this is a table comment';

COMMENT

norman=# \dd test_table

Object descriptions
Name | Object | Description
------------+-------------+-------------------------
test_table | relation(r) | this is a table comment
(1 row)

norman=# comment on column test_table.col1 is 'this is a column comment';

COMMENT

norman=# \dd test_table.col1

Object descriptions
Name | Object | Description
------+--------+-------------
(0 rows)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mitch Vincent 2001-02-16 01:49:36 Re: PostgreSQL vs Oracle vs DB2 vs MySQL - Which should I use?
Previous Message Lincoln Yeoh 2001-02-16 01:00:31 Re: PostgreSQL vs Oracle vs DB2 vs MySQL - Which should I use?