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
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? |