Re: Showing table comments with psql - Mailing list pgsql-general

From Mark Jeffcoat
Subject Re: Showing table comments with psql
Date
Msg-id CAOT_8kZCgnNHph4zoaC5YQBHSDui3+=vovsx+ewdDsCB_kkZaA@mail.gmail.com
Whole thread Raw
In response to Re: Showing table comments with psql  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
On Fri, Jan 4, 2019 at 11:00 AM Pavel Stehule <pavel.stehule@gmail.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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Comparing dates in DDL
Next
From: "David G. Johnston"
Date:
Subject: Re: Comparing dates in DDL