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

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

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

To: Greg Sabino Mullane <htamfids@gmail.com>

Cc: Sadeq Dousti <msdousti@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@lists.postgresql.org

Date: 2025-02-24T00:40:09Z

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

On Sun, Feb 23, 2025 at 4:31 PM Greg Sabino Mullane <htamfids@gmail.com>
wrote:

> On Sun, Feb 23, 2025 at 4:34 PM Sadeq Dousti <msdousti@gmail.com> wrote:
>
>> Totally agree about the naming. There's no other terminology known to me,
>> but I'll definitely think about it. Of course, I'm very open to
>> suggestions from you or anyone else in the community.
>>
>
> The problem is that we are really tight on available letters for a
> bare \d. I immediately thought of "adult" tables (those that are not
> children). But both \da and \dA are used! The only other mnemonic option is
> "\de" where e stands for elder tables (get it? elder because they are not
> children).
>
>
How about:
\pset partition_roots_only 'true'

Then update all relevant queries to respect it.

That way no learning new ways to get the information you want but instead
can set a global filter to suppress those child nodes that really don't
need to be seen normally.

It would be nice if "N partition children suppressed due to
partition_roots_only" would appear in the output somewhere if going this
direction.

David J.