allow to \dtS+ pg_toast.*

Justin Pryzby <pryzby@telsasoft.com>

From: Justin Pryzby <pryzby@telsasoft.com>
To: pgsql-hackers@postgresql.org
Date: 2020-11-30T16:54:36Z
Lists: pgsql-hackers

Attachments

This makes toast tables a bit less special and easier to inspect.

postgres=# \dtS+ pg_toast.pg_toast_2619
 pg_toast | pg_toast_2619 | toast table | pryzbyj | permanent   | heap          | 56 kB | 

This follows commit from last year:
| eb5472da9 make \d pg_toast.foo show its indices ; and, \d toast show its main table

-- 
Justin

Commits

  1. Revert unstable test cases from commit 7d80441d2.

  2. Allow psql's \dt and \di to show TOAST tables and their indexes.