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

Christoph Berg <myon@debian.org>

From: Christoph Berg <myon@debian.org>

To: Sadeq Dousti <msdousti@gmail.com>

Cc: Greg Sabino Mullane <htamfids@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, "David G. Johnston" <david.g.johnston@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>, pgsql-hackers@lists.postgresql.org

Date: 2025-03-27T15:19:55Z

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

Re: Sadeq Dousti
> Thanks Greg and others for the feedback!
> 
> Please find attached the patch for implementing \dN (including \dNt, \dNi,
> \dNit).

I don't care particularly about the choice of letter, but I think this
is the wrong way round. It should be \dtN instead of \dNt.

Is the form \dN actually useful? For partitioned tables, you'd only
get the empty root indexes. If you actually wanted that, there's still
\dtiN.

Christoph