Actually, I responded a bit too hastily. That looks like a bug in psql to
me. I see it in 7.0.3 as well. The query that psql is generating is
incorrect:
SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules
FROM pg_class WHERE relname='table.column';
It should be querying pg_attribute.
It seems \d+ tablename is currently the only way to view column comments.
Hope that helps,
Mike Mascari
mascarm@mascari.com
-----Original Message-----
From: Norman J. Clarke [SMTP:norman@combimatrix.com]
Sent: Thursday, February 15, 2001 8:24 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] how to see column comments?
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)
