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

Поиск
Список
Период
Сортировка
От Chao Li
Тема Re: Fix how some lists are displayed by psql \d+
Дата
Msg-id 071484FC-B420-4B22-9899-3A16086A5637@gmail.com
обсуждение исходный текст
Ответ на Fix how some lists are displayed by psql \d+  (Peter Smith <smithpb2250@gmail.com>)
Список pgsql-hackers

> On Jan 9, 2026, at 06:47, Peter Smith <smithpb2250@gmail.com> wrote:
>
> Hi.
>
> I recently saw that the psql \d+ lists for "Partitions:" are not
> aligned in quite the same way as other lists ("Publications:" etc)
> because they use indents and line breaks differently. e.g. See below:
>
> test_pub=# \d+ part1
>                                    Partitioned table "public.part1"
> Column |  Type   | Collation | Nullable | Default | Storage |
> Compression | Stats target | Description
> --------+---------+-----------+----------+---------+---------+-------------+--------------+-------------
> a      | integer |           |          |         | plain   |
>    |              |
> Partition of: t1 FOR VALUES FROM (0) TO (50)
> Partition constraint: ((a IS NOT NULL) AND (a >= 0) AND (a < 50))
> Partition key: RANGE (a)
> Publications:
>    "pub1"
>    "pub2"
>    "pub_only"
> Partitions: part1_1 FOR VALUES FROM (0) TO (25), PARTITIONED,
>            part1_2 FOR VALUES FROM (25) TO (50)
>
> ~~~
>
> PSA v1
> 0001 - Fix (common code) lists for "Partitions:" and "Child tables:"
> 0002 - Fix list for "Inherits:" in the same way
>
> ~~~
>
> The *patched* result for the same example now looks like below. Notice
> that in passing I also removed the comma separators, which are not
> present in the other footer lists.
>
> test_pub=# \d+ part1
>                                    Partitioned table "public.part1"
> Column |  Type   | Collation | Nullable | Default | Storage |
> Compression | Stats target | Description
> --------+---------+-----------+----------+---------+---------+-------------+--------------+-------------
> a      | integer |           |          |         | plain   |
>    |              |
> Partition of: t1 FOR VALUES FROM (0) TO (50)
> Partition constraint: ((a IS NOT NULL) AND (a >= 0) AND (a < 50))
> Partition key: RANGE (a)
> Publications:
>    "pub1"
>    "pub2"
>    "pub_only"
> Partitions:
>    part1_1 FOR VALUES FROM (0) TO (25), PARTITIONED
>    part1_2 FOR VALUES FROM (25) TO (50)
>
> ======
> Kind Regards,
> Peter Smith.
> Fujitsu Australia
>
<v1-0002-Fix-to-make-psql-d-lists-of-inherits-look-same-as.patch><v1-0001-Fix-to-make-psql-d-lists-of-partitions-look-same-.patch>


This is a simple change, but makes sense to me, making the display looking better.

The code change is straightforward and LGTM.

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







В списке pgsql-hackers по дате отправления: