Re: EXCEPT TABLE - Case inconsistency for describe \d and \dRp+

On Mon, 13 Apr 2026 at 07:45, Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
>
> On Fri, Apr 10, 2026 at 8:19 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >
> > On Fri, Apr 10, 2026 at 12:43 PM Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
> > >
> > > Notice that that the describe publication says:
> > > "Tables:" and "Except tables:" (Lowercase "tables")
> > >
> > > Notice that the describe table says:
> > > "Publications:" and "Except Publications:" (Uppercase "Publications")
> > >
> > > I think they should use a consistent case:
> > > eg1. (both lowercase) Except tables; Except publications, OR
> > > eg2. (bother uppercase) Except Tables; Except Publications
> > >
> >
> > We should follow eg1. I checked few examples where we follow same
> > pattern as eg1:
> >
> > Example-1: (See: "Tables from schemas")
> > postgres=# \dRp+ pub1
> > Publication pub1
> > Owner | All tables | All sequences | Inserts | Updates | Deletes |
> > Truncates | Generated columns | Via root | Description
> > -------+------------+---------------+---------+---------+---------+-----------+-------------------+----------+-------------
> > amit | f | f | t | t | t | t
> > | none | f |
> > Tables from schemas:
> > "sch1"
> >
> > Example-2: ((See: "No connections")
> > postgres=# create user u1 CONNECTION LIMIT 0;
> > CREATE ROLE
> > postgres=# \du u1
> > List of roles
> > Role name | Attributes
> > -----------+----------------
> > u1 | No connections
> >
>
> Hi Amit.
>
> Thanks for the advice.
>
> PSA patch v1 to change "Except Publications" to "Except publications".

The commit message could be improved:
Date: Mon, 13 Apr 2026 12:12:00 +1000
Subject: [PATCH v1] describe table except publications

---
src/bin/psql/describe.c | 2 +-

Other than that, the patch looks good to me.

Regards,
Vignesh.