MIME-Version: 1.0
References: <CAHut+Pu1puO00C-OhgLnAcECzww8MB3Q8DCsvx0cZWHRfs4gBQ@mail.gmail.com>
 <CAHut+PuZ-SPA87FqhyW9zXnwVu4pPo8pT073qBZAhcFTetWYfg@mail.gmail.com> <785CF596-5626-4ECB-AC3D-13FB266D69D0@gmail.com>
In-Reply-To: <785CF596-5626-4ECB-AC3D-13FB266D69D0@gmail.com>
From: Peter Smith <smithpb2250@gmail.com>
Date: Wed, 21 Jan 2026 19:22:44 +1100
Message-ID: <CAHut+PurJVXBJdzTQvq1YWcSQjsgjQcpdK43SOERyfYkpibjNQ@mail.gmail.com>
Subject: Re: Fix how some lists are displayed by psql \d+
To: Chao Li <li.evan.chao@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAHut%2BPurJVXBJdzTQvq1YWcSQjsgjQcpdK43SOERyfYkpibjNQ%40mail.gmail.com>
Precedence: bulk

On Wed, Jan 21, 2026 at 7:05=E2=80=AFPM Chao Li <li.evan.chao@gmail.com> wr=
ote:
>
>
>
> > 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.
> >
> > =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-00=
01-Fix-to-make-psql-d-lists-of-partitions-look-same-.patch>
>
> I still see some difference:
> ```
> evantest=3D# \d+ p_test;
>                                      Partitioned table "public.p_test"
>   Column  |  Type   | Collation | Nullable | Default | Storage  | Compres=
sion | 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.

=3D=3D=3D=3D=3D=3D
Kind Regards
Peter Smith.
Fujitsu Australia