MIME-Version: 1.0
References: 
 <CAHut+Pt3t_tCYwDStkj5fG4Z=YXrHvPBA7iGdh745QipC5zKeg@mail.gmail.com>
 <aeDs7iZUox1bbKAK@alvherre.pgsql>
In-Reply-To: <aeDs7iZUox1bbKAK@alvherre.pgsql>
From: Peter Smith <smithpb2250@gmail.com>
Date: Fri, 17 Apr 2026 09:03:38 +1000
Message-ID: 
 <CAHut+Psq7qmQSQCZA_HZcFv9ADCHDUPqCyFuTKfPDU-GUGihhQ@mail.gmail.com>
Subject: Re: EXCEPT TABLE - Case inconsistency for describe \d and \dRp+
To: =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>
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%2BPsq7qmQSQCZA_HZcFv9ADCHDUPqCyFuTKfPDU-GUGihhQ%40mail.gmail.com>
Precedence: bulk

On Fri, Apr 17, 2026 at 12:10=E2=80=AFAM =C3=81lvaro Herrera <alvherre@kuri=
lemu.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 publication=
s:"
>

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=3D# \d t1
                 Table "public.t1"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 a      | integer |           |          |
Publications:
    "pub1"
    "pub2"
Except publications:
    "pub3"

~~~

SUGGESTION

test_pub=3D# \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.

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