MIME-Version: 1.0
References: 
 <CAHut+Pt3t_tCYwDStkj5fG4Z=YXrHvPBA7iGdh745QipC5zKeg@mail.gmail.com>
 <CAA4eK1KUP5h++hSK6eo--jx=jRJ2TTPqYYmOg=7anCm=__S_0w@mail.gmail.com>
In-Reply-To: 
 <CAA4eK1KUP5h++hSK6eo--jx=jRJ2TTPqYYmOg=7anCm=__S_0w@mail.gmail.com>
From: Peter Smith <smithpb2250@gmail.com>
Date: Mon, 13 Apr 2026 12:14:59 +1000
Message-ID: 
 <CAHut+PvtmM7tCut-K-EWSq0_Hg5ey=M2NreU_Fq80SpUOgmiBw@mail.gmail.com>
Subject: Re: EXCEPT TABLE - Case inconsistency for describe \d and \dRp+
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="0000000000005a2291064f4e0e7d"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHut%2BPvtmM7tCut-K-EWSq0_Hg5ey%3DM2NreU_Fq80SpUOgmiBw%40mail.gmail.com>
Precedence: bulk

--0000000000005a2291064f4e0e7d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Apr 10, 2026 at 8:19=E2=80=AFPM Amit Kapila <amit.kapila16@gmail.co=
m> wrote:
>
> On Fri, Apr 10, 2026 at 12:43=E2=80=AFPM Peter Smith <smithpb2250@gmail.c=
om> 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
>

Hi Amit.

Thanks for the advice.

PSA patch v1 to change "Except Publications" to "Except publications".

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

--0000000000005a2291064f4e0e7d
Content-Type: application/octet-stream;
	name="v1-0001-describe-table-except-publications.patch"
Content-Disposition: attachment;
	filename="v1-0001-describe-table-except-publications.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mnwk6vnk0>
X-Attachment-Id: f_mnwk6vnk0

RnJvbSBkMjhmNGVkZDI4ZTE1YzNhZjY4MmM2YmRhMmMzNGFhNDRlYWE5YzM4IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBTbWl0aCA8cGV0ZXIuYi5zbWl0aEBmdWppdHN1LmNv
bT4KRGF0ZTogTW9uLCAxMyBBcHIgMjAyNiAxMjoxMjowMCArMTAwMApTdWJqZWN0OiBbUEFUQ0gg
djFdIGRlc2NyaWJlIHRhYmxlIGV4Y2VwdCBwdWJsaWNhdGlvbnMKCi0tLQogc3JjL2Jpbi9wc3Fs
L2Rlc2NyaWJlLmMgICAgICAgICAgICAgICAgICAgfCAyICstCiBzcmMvdGVzdC9yZWdyZXNzL2V4
cGVjdGVkL3B1YmxpY2F0aW9uLm91dCB8IDYgKysrLS0tCiAyIGZpbGVzIGNoYW5nZWQsIDQgaW5z
ZXJ0aW9ucygrKSwgNCBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9zcmMvYmluL3BzcWwvZGVz
Y3JpYmUuYyBiL3NyYy9iaW4vcHNxbC9kZXNjcmliZS5jCmluZGV4IDRlOGZmMDAzOTRhLi4yOTFj
NDkzZjU5NCAxMDA2NDQKLS0tIGEvc3JjL2Jpbi9wc3FsL2Rlc2NyaWJlLmMKKysrIGIvc3JjL2Jp
bi9wc3FsL2Rlc2NyaWJlLmMKQEAgLTMzMDYsNyArMzMwNiw3IEBAIGRlc2NyaWJlT25lVGFibGVE
ZXRhaWxzKGNvbnN0IGNoYXIgKnNjaGVtYW5hbWUsCiAJCQkJdHVwbGVzID0gUFFudHVwbGVzKHJl
c3VsdCk7CiAKIAkJCWlmICh0dXBsZXMgPiAwKQotCQkJCXByaW50VGFibGVBZGRGb290ZXIoJmNv
bnQsIF8oIkV4Y2VwdCBQdWJsaWNhdGlvbnM6IikpOworCQkJCXByaW50VGFibGVBZGRGb290ZXIo
JmNvbnQsIF8oIkV4Y2VwdCBwdWJsaWNhdGlvbnM6IikpOwogCiAJCQkvKiBNaWdodCBiZSBhbiBl
bXB0eSBzZXQgLSB0aGF0J3Mgb2sgKi8KIAkJCWZvciAoaSA9IDA7IGkgPCB0dXBsZXM7IGkrKykK
ZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcHVibGljYXRpb24ub3V0IGIv
c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wdWJsaWNhdGlvbi5vdXQKaW5kZXggYTkwNTlhMzkx
MzguLmQwMjhlOWJlODY2IDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3B1
YmxpY2F0aW9uLm91dAorKysgYi9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3B1YmxpY2F0aW9u
Lm91dApAQCAtMjUyLDcgKzI1Miw3IEBAIEluZGV4ZXM6CiAgICAgInRlc3RwdWJfdGJsMV9wa2V5
IiBQUklNQVJZIEtFWSwgYnRyZWUgKGlkKQogUHVibGljYXRpb25zOgogICAgICJ0ZXN0cHViX2Zv
cmFsbHRhYmxlcyIKLUV4Y2VwdCBQdWJsaWNhdGlvbnM6CitFeGNlcHQgcHVibGljYXRpb25zOgog
ICAgICJ0ZXN0cHViX2ZvcmFsbHRhYmxlc19leGNlcHR0YWJsZSIKICAgICAidGVzdHB1Yl9mb3Jh
bGx0YWJsZXNfZXhjZXB0dGFibGUxIgogCkBAIC00MzUsNyArNDM1LDcgQEAgRXhjZXB0IHRhYmxl
czoKIC0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLQog
IGEgICAgICB8IGludGVnZXIgfCAgICAgICAgICAgfCAgICAgICAgICB8IAogUGFydGl0aW9uIG9m
OiB0ZXN0cHViX3Jvb3QgRk9SIFZBTFVFUyBGUk9NICgwKSBUTyAoMTAwKQotRXhjZXB0IFB1Ymxp
Y2F0aW9uczoKK0V4Y2VwdCBwdWJsaWNhdGlvbnM6CiAgICAgInRlc3RwdWI4IgogCiBcZCB0ZXN0
cHViX3Jvb3QKQEAgLTQ0NCw3ICs0NDQsNyBAQCBFeGNlcHQgUHVibGljYXRpb25zOgogLS0tLS0t
LS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tCiAgYSAgICAgIHwg
aW50ZWdlciB8ICAgICAgICAgICB8ICAgICAgICAgIHwgCiBQYXJ0aXRpb24ga2V5OiBSQU5HRSAo
YSkKLUV4Y2VwdCBQdWJsaWNhdGlvbnM6CitFeGNlcHQgcHVibGljYXRpb25zOgogICAgICJ0ZXN0
cHViOCIKIE51bWJlciBvZiBwYXJ0aXRpb25zOiAxIChVc2UgXGQrIHRvIGxpc3QgdGhlbS4pCiAK
LS0gCjIuNDcuMwoK
--0000000000005a2291064f4e0e7d--