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

[Peter Smith]

On Fri, Apr 10, 2026 at 8:19 PM Amit Kapila <amit.kapil...@gmail.com> wrote:
>
> On Fri, Apr 10, 2026 at 12:43 PM Peter Smith <smithpb2...@gmail.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

v1-0001-describe-table-except-publications.patch
Description: Binary data