RE: how to see column comments? - Mailing list pgsql-general

From Mike Mascari
Subject RE: how to see column comments?
Date
Msg-id 01C097A0.3DE95FC0.mascarm@mascari.com
Whole thread Raw
In response to how to see column comments?  ("Norman J. Clarke" <norman@combimatrix.com>)
List pgsql-general
Try \d+ test_table.

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)


pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: PostgreSQL vs Oracle vs DB2 vs MySQL - Which should I use?
Next
From: Christopher Sawtell
Date:
Subject: Re: how to see column comments?