Re: Fix how some lists are displayed by psql \d+

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Fix how some lists are displayed by psql \d+
Date: 2026-01-21 08:22:44
Message-ID: CAHut+PurJVXBJdzTQvq1YWcSQjsgjQcpdK43SOERyfYkpibjNQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jan 21, 2026 at 7:05 PM Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> wrote:
>
>
>
> > On Jan 21, 2026, at 10:58, Peter Smith <smithpb2250(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2026-01-21 08:30:12 Re: Fix how some lists are displayed by psql \d+
Previous Message Steven Niu 2026-01-21 08:18:41 Re: file_fdw: Support multi-line HEADER option.