make \d pg_toast.foo show its indices - Mailing list pgsql-hackers

From Justin Pryzby
Subject make \d pg_toast.foo show its indices
Date
Msg-id 20190422154902.GH14223@telsasoft.com
Whole thread Raw
Responses Re: make \d pg_toast.foo show its indices
List 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

Attachment

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: finding changed blocks using WAL scanning
Next
From: Bruce Momjian
Date:
Subject: Re: finding changed blocks using WAL scanning