Horton
Menu

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

Álvaro Herrera <alvherre@kurilemu.de>

View thread
From: Álvaro Herrera <alvherre@kurilemu.de>
To: Peter Smith <smithpb2250@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-04-16T14:10:33Z
Lists: pgsql-hackers 
On 2026-Apr-10, Peter Smith wrote:

> # -- describe the tables
> # \d t1
>                 Table "public.t1"
> Column | Type   | Collation | Nullable | Default
> --------+---------+-----------+----------+---------
> a      | integer |           |          |
> Except Publications:
>   "pub1"

I have a hard time understanding what an "except publication" is.  I
think this would be clearer if the header said "Excluded from publications:"


A footer section under a publication saying "Except tables" on the other
hand is crystal clear.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. psql: Improve describe footer titles for publications.

  2. Fix capitalization in publication describe output.

  3. Allow table exclusions in publications via EXCEPT TABLE.