public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: yuanchao zhang <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: A suggestion about the usage manual of \d command
Date: Fri, 27 Feb 2026 07:12:39 -0700
Message-ID: <CAKFQuwbM3Vk9MeSa5e6G6APY5A8vmtOL_sh=7fYy6YqOpsooJg@mail.gmail.com> (raw)
In-Reply-To: <CAADcJZO6M3aOfkY344wQUjRiOJCgPtfiMBCtqyuFzp6o8_5nxw@mail.gmail.com>
References: <CAADcJZO6M3aOfkY344wQUjRiOJCgPtfiMBCtqyuFzp6o8_5nxw@mail.gmail.com>
On Friday, February 27, 2026, yuanchao zhang <[email protected]> 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.
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: A suggestion about the usage manual of \d command
In-Reply-To: <CAKFQuwbM3Vk9MeSa5e6G6APY5A8vmtOL_sh=7fYy6YqOpsooJg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox