MIME-Version: 1.0
References: 
 <CAHut+Pt3t_tCYwDStkj5fG4Z=YXrHvPBA7iGdh745QipC5zKeg@mail.gmail.com>
In-Reply-To: 
 <CAHut+Pt3t_tCYwDStkj5fG4Z=YXrHvPBA7iGdh745QipC5zKeg@mail.gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
Date: Fri, 10 Apr 2026 15:49:34 +0530
Message-ID: 
 <CAA4eK1KUP5h++hSK6eo--jx=jRJ2TTPqYYmOg=7anCm=__S_0w@mail.gmail.com>
Subject: Re: EXCEPT TABLE - Case inconsistency for describe \d and \dRp+
To: Peter Smith <smithpb2250@gmail.com>
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/CAA4eK1KUP5h%2B%2BhSK6eo--jx%3DjRJ2TTPqYYmOg%3D7anCm%3D__S_0w%40mail.gmail.com>
Precedence: bulk

On Fri, Apr 10, 2026 at 12:43=E2=80=AFPM Peter Smith <smithpb2250@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=3D# \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=3D# create user u1 CONNECTION LIMIT 0;
CREATE ROLE
postgres=3D# \du u1
       List of roles
 Role name |   Attributes
-----------+----------------
 u1        | No connections

--=20
With Regards,
Amit Kapila.