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-28T10:27:20Z

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
> > I think this is the wrong way round.
> > It should be \dtN instead of \dNt.
> 
> Hi Christoph,
> The order does not matter, the user can use \dNt or \dtN, as they do
> exactly the same thing. Letters coming after \d can be freely permuted. If
> you mean a change to the documentation or tests, I can apply whatever order
> makes more sense, as I don't have any particular preference.

Oh ok, that's perfect then.

        HELP0("  \\dn[Sx+] [PATTERN]     list schemas\n");
+       HELP0("  \\dN[Sx+] [PATTERN]     list tables and indexes (no partitions)\n");
        HELP0("  \\do[Sx+] [OPPTRN [TYPEPTRN [TYPEPTRN]]]\n"

Is this really a new "top-level" \d command and not a flag for the
existing \d commands? I would think that the help texts should place
the N next to S which is a similar "show different set of things"
modifier:

\d[NSx+]                list tables, views, and sequences
\di[NSx+] [PATTERN]     list indexes
\dt[NSx+] [PATTERN]     list tables

For documentation and tests, the N should be at the end like S is at
the end in \dt[S+].

Christoph