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

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".

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