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.
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?
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 ┌────────┬────────────┬───────┬───────┬─────────┬─────────────────────────┐ │ Schema │ Name │ Type │ Owner │ Size │ Description │ ╞════════╪════════════╪═══════╪═══════╪═════════╪═════════════════════════╡ │ public │ test_table │ table │ pavel │ 0 bytes │ this is a table comment │ └────────┴────────────┴───────┴───────┴─────────┴─────────────────────────┘ (1 row)