Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.300.41.1.7\))
Subject: Re: Fix how some lists are displayed by psql \d+
From: Chao Li <li.evan.chao@gmail.com>
In-Reply-To: <CAHut+PurJVXBJdzTQvq1YWcSQjsgjQcpdK43SOERyfYkpibjNQ@mail.gmail.com>
Date: Wed, 21 Jan 2026 16:30:12 +0800
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <8048C321-FECA-4ECD-B022-54D842151B42@gmail.com>
References: <CAHut+Pu1puO00C-OhgLnAcECzww8MB3Q8DCsvx0cZWHRfs4gBQ@mail.gmail.com>
 <CAHut+PuZ-SPA87FqhyW9zXnwVu4pPo8pT073qBZAhcFTetWYfg@mail.gmail.com>
 <785CF596-5626-4ECB-AC3D-13FB266D69D0@gmail.com>
 <CAHut+PurJVXBJdzTQvq1YWcSQjsgjQcpdK43SOERyfYkpibjNQ@mail.gmail.com>
To: Peter Smith <smithpb2250@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/8048C321-FECA-4ECD-B022-54D842151B42%40gmail.com>
Precedence: bulk


> On Jan 21, 2026, at 16:22, Peter Smith <smithpb2250@gmail.com> wrote:
>=20
> On Wed, Jan 21, 2026 at 7:05=E2=80=AFPM Chao Li =
<li.evan.chao@gmail.com> wrote:
>>=20
>>=20
>>=20
>>> On Jan 21, 2026, at 10:58, Peter Smith <smithpb2250@gmail.com> =
wrote:
>>>=20
>>> A rebase was needed for some more test expected output changes.
>>>=20
>>> PSA v2.
>>>=20
>>> =3D=3D=3D=3D=3D=3D
>>> Kind Regards,
>>> Peter Smith.
>>> Fujitsu Australia
>>> =
<v2-0002-Fix-to-make-psql-d-lists-of-inherits-look-same-as.patch><v2-0001-=
Fix-to-make-psql-d-lists-of-partitions-look-same-.patch>
>>=20
>> I still see some difference:
>> ```
>> evantest=3D# \d+ p_test;
>>                                     Partitioned table "public.p_test"
>>  Column  |  Type   | Collation | Nullable | Default | Storage  | =
Compression | Stats target | Description
>> =
----------+---------+-----------+----------+---------+----------+---------=
----+--------------+-------------
>> id       | integer |           |          |         | plain    |      =
       |              |
>> username | text    |           |          |         | extended |      =
       |              |
>> category | text    |           |          |         | extended |      =
       |              |
>> Partition key: LIST (category)
>> Indexes:
>>    "idx_p_test_id" btree (id)
>> Partitions:
>>    p_test_v1 FOR VALUES IN ('A')
>>    p_test_v2 FOR VALUES IN ('B')
>> ```
>>=20
>> The index name is quoted, but the partition names are not.
>>=20
>=20
> AFAICT
> Indexes are quoted
> Constraints are quoted
> Publications are also quoted
>=20
> Partitions are NOT quoted
> Inherits are NOT quoted
>=20
> ~
>=20
> Please confirm --- So, you are expecting that Partitions and Child
> tables should also be quoted, so that everything looks the same?
>=20
> This is scope creep from the original intent of this thread, so I will
> look at doing this in a separate patch 0003.
>=20
> =3D=3D=3D=3D=3D=3D
> Kind Regards
> Peter Smith.
> Fujitsu Australia

Actually I don=E2=80=99t know the rule, which should be quoted and which =
should not. Is the inconstancy a blocker?

So, I was just pointing out the inconsistency, and I want to hear a =
clarification from someone.

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/