Re: Showing table comments with psql

On Fri, Jan 4, 2019 at 11:00 AM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> 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
> ┌────────┬────────────┬───────┬───────┬─────────┬─────────────────────────┐
> │ Schema │ Name │ Type │ Owner │ Size │ Description │
> ╞════════╪════════════╪═══════╪═══════╪═════════╪═════════════════════════╡
> │ public │ test_table │ table │ pavel │ 0 bytes │ this is a table comment │
> └────────┴────────────┴───────┴───────┴─────────┴─────────────────────────┘
> (1 row)
>

I was so close! That works; thank you very much for your help, Pavel.

--
Mark Jeffcoat
Austin, TX