Re: psql \dh: List High-Level (Root) Tables and Indexes - Mailing list 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