MIME-Version: 1.0
From: yuanchao zhang <zhangyc0706@gmail.com>
Date: Fri, 27 Feb 2026 16:06:22 +0800
Message-ID: 
 <CAADcJZO6M3aOfkY344wQUjRiOJCgPtfiMBCtqyuFzp6o8_5nxw@mail.gmail.com>
Subject: A suggestion about the usage manual of \d command
To: pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000234477064bc9b719"
Archived-At: 
 <https://www.postgresql.org/message-id/CAADcJZO6M3aOfkY344wQUjRiOJCgPtfiMBCtqyuFzp6o8_5nxw%40mail.gmail.com>
Precedence: bulk

--000000000000234477064bc9b719
Content-Type: text/plain; charset="UTF-8"

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.

Best regards
Yuanchao Zhang

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

<div dir=3D"ltr"><div>Hi,</div>I created a domain object named `numeric` us=
ing the following statement: `CREATE DOMAIN numeric AS NUMERIC(12,2) DEFAUL=
T 0 CHECK (VALUE &gt;=3D 0);` After executing this SQL, it indicated that t=
he domain was created successfully. However, when I executed `\dD` in psql,=
 the created domain could not be displayed.<br><br>The reason is that the n=
ame 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 rel=
evant explanations, which can mislead users. Users might think an object wa=
s successfully created, but the `\d` command doesn&#39;t display it, which =
could make beginners doubt whether the object was created successfully. I s=
uggest adding necessary explanations to the `\d` command&#39;s manual.<div>=
<br></div><div>Best regards</div><div>Yuanchao Zhang</div></div>

--000000000000234477064bc9b719--