Re: Fix how some lists are displayed by psql \d+ - Mailing list pgsql-hackers

From Chao Li
Subject Re: Fix how some lists are displayed by psql \d+
Date
Msg-id 8048C321-FECA-4ECD-B022-54D842151B42@gmail.com
Whole thread Raw
In response to Re: Fix how some lists are displayed by psql \d+  (Peter Smith <smithpb2250@gmail.com>)
Responses Re: Fix how some lists are displayed by psql \d+
List pgsql-hackers

> On Jan 21, 2026, at 16:22, Peter Smith <smithpb2250@gmail.com> wrote:
>
> On Wed, Jan 21, 2026 at 7:05 PM Chao Li <li.evan.chao@gmail.com> wrote:
>>
>>
>>
>>> On Jan 21, 2026, at 10:58, Peter Smith <smithpb2250@gmail.com> wrote:
>>>
>>> A rebase was needed for some more test expected output changes.
>>>
>>> PSA v2.
>>>
>>> ======
>>> 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>
>>
>> I still see some difference:
>> ```
>> evantest=# \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')
>> ```
>>
>> The index name is quoted, but the partition names are not.
>>
>
> AFAICT
> Indexes are quoted
> Constraints are quoted
> Publications are also quoted
>
> Partitions are NOT quoted
> Inherits are NOT quoted
>
> ~
>
> Please confirm --- So, you are expecting that Partitions and Child
> tables should also be quoted, so that everything looks the same?
>
> This is scope creep from the original intent of this thread, so I will
> look at doing this in a separate patch 0003.
>
> ======
> Kind Regards
> Peter Smith.
> Fujitsu Australia

Actually I don’t 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/







pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Fix how some lists are displayed by psql \d+
Next
From: jian he
Date:
Subject: Re: finish TODOs in to_json_is_immutable, to_jsonb_is_immutable also add tests on it