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

From: Christoph Berg <myon(at)debian(dot)org>
To: Sadeq Dousti <msdousti(at)gmail(dot)com>
Cc: Greg Sabino Mullane <htamfids(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: psql \dh: List High-Level (Root) Tables and Indexes
Date: 2025-03-28 10:27:20
Message-ID: Z-Z5iCaITigJD9Qg@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2025-03-28 10:35:26 Re: Test to dump and restore objects left behind by regression
Previous Message Richard Guo 2025-03-28 10:19:04 Re: duplicated comments on get_relation_constraints