MIME-Version: 1.0
In-Reply-To: 
 <CAADcJZO6M3aOfkY344wQUjRiOJCgPtfiMBCtqyuFzp6o8_5nxw@mail.gmail.com>
References: 
 <CAADcJZO6M3aOfkY344wQUjRiOJCgPtfiMBCtqyuFzp6o8_5nxw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 27 Feb 2026 07:12:39 -0700
Message-ID: 
 <CAKFQuwbM3Vk9MeSa5e6G6APY5A8vmtOL_sh=7fYy6YqOpsooJg@mail.gmail.com>
Subject: Re: A suggestion about the usage manual of \d command
To: yuanchao zhang <zhangyc0706@gmail.com>
Cc: "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000784192064bced4ee"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwbM3Vk9MeSa5e6G6APY5A8vmtOL_sh%3D7fYy6YqOpsooJg%40mail.gmail.com>
Precedence: bulk

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

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 user=
s.
> Users might think an object was successfully created, but the `\d` comman=
d
> doesn't display it, which could make beginners doubt whether the object w=
as
> 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 se=
e 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.

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

On Friday, February 27, 2026, yuanchao zhang &lt;<a href=3D"mailto:zhangyc0=
706@gmail.com">zhangyc0706@gmail.com</a>&gt; wrote:<br><blockquote class=3D=
"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding=
-left:1ex"><div dir=3D"ltr"><div>Hi,</div>I created a domain object named `=
numeric` using the following statement: `CREATE DOMAIN numeric AS NUMERIC(1=
2,2) DEFAULT 0 CHECK (VALUE &gt;=3D 0);` After executing this SQL, it indic=
ated that the domain was created successfully. However, when I executed `\d=
D` in psql, the created domain could not be displayed.<br><br>The reason is=
 that the name I used is the same as a built-in type (of course, similar is=
sues exist not only with domains). However, our manual for the `\dD` comman=
d lacks relevant explanations, which can mislead users. Users might think a=
n object was successfully created, but the `\d` command doesn&#39;t display=
 it, which could make beginners doubt whether the object was created succes=
sfully. I suggest adding necessary explanations to the `\d` command&#39;s m=
anual.</div></blockquote><div><br></div><div>As explained in your bug repor=
t the documentation already covers namespaces, types, and the pattern argum=
ent 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 to explain your example ca=
se is very unappealing.=C2=A0 I honestly don=E2=80=99t see this going anywh=
ere unless you propose specific text and location suggestions for what such=
 a patch should look like.=C2=A0 A real patch is even better, but with soli=
d enough ideas someone might volunteer to bundle it all into sgml format.</=
div><div><br></div><div>David J.</div><div><br></div>

--000000000000784192064bced4ee--