Re: Showing table comments with psql
| От | Pavel Stehule |
|---|---|
| Тема | Re: Showing table comments with psql |
| Дата | |
| Msg-id | CAFj8pRDPpWi1EAdyYx+AadKey-zs+hidnsyfdvU627vZAm3Xkw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Showing table comments with psql (Mark Jeffcoat <mark.e.jeffcoat@gmail.com>) |
| Ответы |
Re: Showing table comments with psql
|
| Список | pgsql-general |
Hi
pá 4. 1. 2019 v 17:57 odesílatel Mark Jeffcoat <mark.e.jeffcoat@gmail.com> 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)
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)
postgres=#
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)
postgres=#
В списке pgsql-general по дате отправления: