MIME-Version: 1.0
References: 
 <CAADcJZO6M3aOfkY344wQUjRiOJCgPtfiMBCtqyuFzp6o8_5nxw@mail.gmail.com>
 <CAKFQuwbM3Vk9MeSa5e6G6APY5A8vmtOL_sh=7fYy6YqOpsooJg@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwbM3Vk9MeSa5e6G6APY5A8vmtOL_sh=7fYy6YqOpsooJg@mail.gmail.com>
From: yuanchao zhang <zhangyc0706@gmail.com>
Date: Sat, 28 Feb 2026 09:02:47 +0800
Message-ID: 
 <CAADcJZOaae_jsiEQuW=58hwwPjZB47Jv9Mhf8H4KAJ_GANwa5Q@mail.gmail.com>
Subject: Re: A suggestion about the usage manual of \d command
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000262279064bd7eae2"
Archived-At: 
 <https://www.postgresql.org/message-id/CAADcJZOaae_jsiEQuW%3D58hwwPjZB47Jv9Mhf8H4KAJ_GANwa5Q%40mail.gmail.com>
Precedence: bulk

--000000000000262279064bd7eae2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Okay, no problem. I just encountered this issue and was experiencing some
inconvenience as a user. If I have more detailed thoughts, I can add them
later. Thank you for your reply anyway.

Best regards
Yuanchao Zhang

David G. Johnston <david.g.johnston@gmail.com> =E4=BA=8E2026=E5=B9=B42=E6=
=9C=8827=E6=97=A5=E5=91=A8=E4=BA=94 22:12=E5=86=99=E9=81=93=EF=BC=9A

> On Friday, February 27, 2026, yuanchao zhang <zhangyc0706@gmail.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 >=3D 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 use=
rs.
>> Users might think an object was successfully created, but the `\d` comma=
nd
>> 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 =E2=80=9C\dD=E2=80=
=9D meta command to
> explain your example case is very unappealing.  I honestly don=E2=80=99t =
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 sgm=
l
> format.
>
> David J.
>
>

--000000000000262279064bd7eae2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Okay, no problem. I just encountered this issue and was ex=
periencing some inconvenience as a user. If I have more detailed thoughts, =
I can add them later. Thank you for your reply anyway.<div><br></div><div><=
div>Best regards</div><font color=3D"#888888"><div>Yuanchao Zhang</div></fo=
nt></div></div><br><div class=3D"gmail_quote gmail_quote_container"><div di=
r=3D"ltr" class=3D"gmail_attr">David G. Johnston &lt;<a href=3D"mailto:davi=
d.g.johnston@gmail.com">david.g.johnston@gmail.com</a>&gt; =E4=BA=8E2026=E5=
=B9=B42=E6=9C=8827=E6=97=A5=E5=91=A8=E4=BA=94 22:12=E5=86=99=E9=81=93=EF=BC=
=9A<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px =
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Friday, F=
ebruary 27, 2026, yuanchao zhang &lt;<a href=3D"mailto:zhangyc0706@gmail.co=
m" target=3D"_blank">zhangyc0706@gmail.com</a>&gt; wrote:<br><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Hi,</div>I create=
d a domain object named `numeric` using the following statement: `CREATE DO=
MAIN numeric AS NUMERIC(12,2) DEFAULT 0 CHECK (VALUE &gt;=3D 0);` After exe=
cuting this SQL, it indicated that the domain was created successfully. How=
ever, when I executed `\dD` in psql, the created domain could not be displa=
yed.<br><br>The reason is that the name I used is the same as a built-in ty=
pe (of course, similar issues exist not only with domains). However, our ma=
nual for the `\dD` command lacks relevant explanations, which can mislead u=
sers. Users might think an object was successfully created, but the `\d` co=
mmand doesn&#39;t display it, which could make beginners doubt whether the =
object was created successfully. I suggest adding necessary explanations to=
 the `\d` command&#39;s manual.</div></blockquote><div><br></div><div>As ex=
plained in your bug report the documentation already covers namespaces, typ=
es, and the pattern argument to the \d meta commands.=C2=A0 Covering all of=
 that within the scope of the specific =E2=80=9C\dD=E2=80=9D meta command t=
o explain your example case is very unappealing.=C2=A0 I honestly don=E2=80=
=99t see this going anywhere unless you propose specific text and location =
suggestions for what such a patch should look like.=C2=A0 A real patch is e=
ven better, but with solid enough ideas someone might volunteer to bundle i=
t all into sgml format.</div><div><br></div><div>David J.</div><div><br></d=
iv>
</blockquote></div>

--000000000000262279064bd7eae2--