MIME-Version: 1.0
References: 
 <CAHut+Pt3t_tCYwDStkj5fG4Z=YXrHvPBA7iGdh745QipC5zKeg@mail.gmail.com>
 <aeDs7iZUox1bbKAK@alvherre.pgsql>
 <CAHut+Psq7qmQSQCZA_HZcFv9ADCHDUPqCyFuTKfPDU-GUGihhQ@mail.gmail.com>
 <CAA4eK1LKQTHkVWdrS9vBfiaAf5kVuU-qOx_FD2u1F4zB9hz4PA@mail.gmail.com>
In-Reply-To: 
 <CAA4eK1LKQTHkVWdrS9vBfiaAf5kVuU-qOx_FD2u1F4zB9hz4PA@mail.gmail.com>
From: Peter Smith <smithpb2250@gmail.com>
Date: Fri, 17 Apr 2026 18:45:53 +1000
Message-ID: 
 <CAHut+Puyt4DTq9E+EJR8zNeKhPSAaKh6JWUOfn1U62ESv2kz_Q@mail.gmail.com>
Subject: Re: EXCEPT TABLE - Case inconsistency for describe \d and \dRp+
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>,
	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%2BPuyt4DTq9E%2BEJR8zNeKhPSAaKh6JWUOfn1U62ESv2kz_Q%40mail.gmail.com>
Precedence: bulk

On Fri, Apr 17, 2026 at 3:24=E2=80=AFPM Amit Kapila <amit.kapila16@gmail.co=
m> wrote:
>
> On Fri, Apr 17, 2026 at 4:34=E2=80=AFAM Peter Smith <smithpb2250@gmail.co=
m> wrote:
> >
> > On Fri, Apr 17, 2026 at 12:10=E2=80=AFAM =C3=81lvaro 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 publica=
tions:"
> > >
> >
> > 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"
> >
> > ~~~
> >
>
> +1 for the proposal. It makes the description clear.
>

OK. Thanks.

Next question: am I only changing this for the table describe (\d)?

I am asking because I noticed the schema describe (\dn) also has a
footer called "Publications:".

----------
test_pub=3D# CREATE PUBLICATION pub7 FOR TABLES IN SCHEMA my_schema;
CREATE PUBLICATION
test_pub=3D# \dn+ my_schema
                    List of schemas
   Name    |  Owner   | Access privileges | Description
-----------+----------+-------------------+-------------
 my_schema | postgres |                   |
Publications:
    "pub7"
----------

Would you like this schema footer also changed to say "Included in
publications:"?

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