Search Postgresql Archives

Re: Showing table comments with psql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Jan 4, 2019 at 11:00 AM Pavel Stehule <pavel.stehule@xxxxxxxxx> 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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux