Showing table comments with psql

From: Mark Jeffcoat <mark(dot)e(dot)jeffcoat(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Showing table comments with psql
Date: 2019-01-04 16:02:54
Message-ID: CAPN82eQxCwgxMYjRKUmWEpv=F30CVE6cAv5HO4n-9kkaTKfQeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm creating table and view comments with "COMMENT ON", and I can find
the comment in pg_description, but I can't find a way to show the
table comments using psql.

$ psql --version
psql (PostgreSQL) 11.1 (Debian 11.1-1+b2)

I'd expect to see table comments by using \d+, and found an old post
on this list where \dd worked; neither work for me today. Am I looking
in the right place? Is this a regression?

Thank you.

postgres=# create table test_table (col1 integer);
CREATE TABLE

postgres=# comment on table test_table is 'this is a table comment';
COMMENT

postgres=# \d+ test_table
Table "public.test_table"
Column | Type | Collation | Nullable | Default | Storage | Stats
target | Description
--------+---------+-----------+----------+---------+---------+--------------+-------------
col1 | integer | | | | plain | |

postgres=# \dd test_table
Object descriptions
Schema | Name | Object | Description
--------+------+--------+-------------
(0 rows)

postgres=# select * from pg_description where objoid = (select oid
from pg_class where relname = 'test_table');
objoid | classoid | objsubid | description
--------+----------+----------+-------------------------
714760 | 1259 | 0 | this is a table comment
(1 row)

--
Mark Jeffcoat
Austin, TX

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon AUBERT 2019-01-04 16:12:44 (Again) Column Store on PostGreSQL
Previous Message Rob Sargent 2019-01-04 16:02:34 Re: Use bytearray for blobs or not?