Re: psql \dh: List High-Level (Root) Tables and Indexes

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: "David G. Johnston" <david.g.johnston@gmail.com>

Cc: Greg Sabino Mullane <htamfids@gmail.com>, Sadeq Dousti <msdousti@gmail.com>, pgsql-hackers@lists.postgresql.org

Date: 2025-02-24T05:16:04Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

psql \dP: list partitioned tables and indexes
- 1c5d9270e339 12.0 cited

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> How about:
> \pset partition_roots_only 'true'

FWIW, I don't especially love this idea.  None of our existing
\d-type commands use pset parameters for filtering, and I don't
see a reason to believe that people would typically want this
to be a persistent setting.  I'd guess that sometimes you want
the tables filtered one way and sometimes the other.

			regards, tom lane