make \d pg_toast.foo show its indices

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема make \d pg_toast.foo show its indices
Дата
Msg-id 20190422154902.GH14223@telsasoft.com
обсуждение исходный текст
Ответы Re: make \d pg_toast.foo show its indices  (Rafia Sabih <rafia.pghackers@gmail.com>)
Список pgsql-hackers
It's deliberate that \dt doesn't show toast tables.
\d shows them, but doesn't show their indices.

It seems to me that their indices should be shown, without having to think and
know to query pg_index.

postgres=# \d pg_toast.pg_toast_2600
TOAST table "pg_toast.pg_toast_2600"
   Column   |  Type   
------------+---------
 chunk_id   | oid
 chunk_seq  | integer
 chunk_data | bytea
Indexes:
    "pg_toast_2600_index" PRIMARY KEY, btree (chunk_id, chunk_seq)

Justin

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: finding changed blocks using WAL scanning
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: finding changed blocks using WAL scanning