Re: Showing table comments with psql

2019-01-04 Thread Mark Jeffcoat
On Fri, Jan 4, 2019 at 11:00 AM Pavel Stehule wrote: > postgres=# create table test_table (col1 integer); > CREATE TABLE > postgres=# comment on table test_table is 'this is a table comment'; > COMMENT > postgres=# \dt+ > List of relations > ┌┬┬──

Re: Showing table comments with psql

2019-01-04 Thread Pavel Stehule
Hi pá 4. 1. 2019 v 17:57 odesílatel Mark Jeffcoat napsal: > 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) >

Showing table comments with psql

2019-01-04 Thread Mark Jeffcoat
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 th