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

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>

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

Cc: "David G. Johnston" <david.g.johnston@gmail.com>, Greg Sabino Mullane <htamfids@gmail.com>, Sadeq Dousti <msdousti@gmail.com>, pgsql-hackers@lists.postgresql.org

Date: 2025-02-24T06:22:15Z

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

po 24. 2. 2025 v 6:16 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:

> "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.
>

There can be numeric parameter that can specify the deep - some like

\dP 0

Regards

Pavel

>
>                         regards, tom lane
>
>
>