Re: A suggestion about the usage manual of \d command

On Friday, February 27, 2026, yuanchao zhang <zhangyc0706(at)gmail(dot)com> wrote:

> Hi,
> I created a domain object named `numeric` using the following statement:
> `CREATE DOMAIN numeric AS NUMERIC(12,2) DEFAULT 0 CHECK (VALUE >= 0);`
> After executing this SQL, it indicated that the domain was created
> successfully. However, when I executed `\dD` in psql, the created domain
> could not be displayed.
>
> The reason is that the name I used is the same as a built-in type (of
> course, similar issues exist not only with domains). However, our manual
> for the `\dD` command lacks relevant explanations, which can mislead users.
> Users might think an object was successfully created, but the `\d` command
> doesn't display it, which could make beginners doubt whether the object was
> created successfully. I suggest adding necessary explanations to the `\d`
> command's manual.
>

As explained in your bug report the documentation already covers
namespaces, types, and the pattern argument to the \d meta commands.
Covering all of that within the scope of the specific “\dD” meta command to
explain your example case is very unappealing. I honestly don’t see this
going anywhere unless you propose specific text and location suggestions
for what such a patch should look like. A real patch is even better, but
with solid enough ideas someone might volunteer to bundle it all into sgml
format.

David J.