Re: EXCEPT TABLE - Case inconsistency for describe \d and \dRp+
Peter Smith <smithpb2250@gmail.com>
From: Peter Smith <smithpb2250@gmail.com>
To: Álvaro Herrera <alvherre@kurilemu.de>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-04-16T23:03:38Z
Lists: pgsql-hackers
On Fri, Apr 17, 2026 at 12:10 AM Álvaro Herrera <alvherre@kurilemu.de> wrote:
>
> On 2026-Apr-10, Peter Smith wrote:
>
> > # -- describe the tables
> > # \d t1
> > Table "public.t1"
> > Column | Type | Collation | Nullable | Default
> > --------+---------+-----------+----------+---------
> > a | integer | | |
> > Except Publications:
> > "pub1"
>
> I have a hard time understanding what an "except publication" is. I
> think this would be clearer if the header said "Excluded from publications:"
>
I agree that your suggestion is clearer.
If we make that change, then should the "Publications:" footer also be
modified similarly (to "Included in publications:") so they match?
e.g.
CURRENTLY
test_pub=# \d t1
Table "public.t1"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
a | integer | | |
Publications:
"pub1"
"pub2"
Except publications:
"pub3"
~~~
SUGGESTION
test_pub=# \d t1
Table "public.t1"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
a | integer | | |
Included in publications:
"pub1"
"pub2"
Excluded from publications:
"pub3"
~~~
I will wait for more opinions/consensus before providing a patch.
======
Kind Regards,
Peter Smith.
Fujitsu Australia
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
psql: Improve describe footer titles for publications.
- 2e1d4fdb10e6 19 (unreleased) landed
-
Fix capitalization in publication describe output.
- 8f81c9235162 19 (unreleased) landed
-
Allow table exclusions in publications via EXCEPT TABLE.
- fd366065e06a 19 (unreleased) cited