Postgres Pro
Downloads
Home   >   mailing lists

Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table
Date
Msg-id 20190506163359.GA29291@alvherre.pgsql
Whole thread Raw
In response to Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
Tree view 
On 2019-May-06, Justin Pryzby wrote:

> Perhaps ... but TOAST is an implementation detail, and I think it should rarely
> be important to know the toast table for a given table.

I'm with Andres -- while it's admittedly a rare need, it is a real one.

Sometimes I wish for \d++ which would display internal details too obscure
to show in the regular \d+, such as the toast table name.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: make \d pg_toast.foo show its indices
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: First-draft release notes for back branches are up