Re: [PATCH] psql: add \dcs to list all constraints

Tatsuro Yamada <yamatattsu@gmail.com>

From: Tatsuro Yamada <yamatattsu@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jim Jones <jim.jones@uni-muenster.de>, pgsql-hackers <pgsql-hackers@postgresql.org>, Álvaro Herrera <alvherre@kurilemu.de>
Date: 2026-01-15T06:32:51Z
Lists: pgsql-hackers

Attachments

Hi Tom and Jim,

>The next patch will include the following changes:
>
>- Rename the command from \dcs to \dCN (proposed by Tom. Thanks!)
>- Join pg_class in the query only when the "+" option is used
>  (identified through Jim's additional testing. Thanks!)

I have prepared a new patch and am sending it here.
Please find the attached file.


>Note: The following two points, which were discussed in the previous
email,
>will be addressed once the discussion is settled:
>
>- Changing the column order displayed by the \dCN command
>- Adding domain constraints to the list of displayed items

I have shared my thoughts on the two points raised by Tom in the email
below, and I would appreciate your comments.


https://www.postgresql.org/message-id/CAOKkKFuYfdvpQ7eSYWxB1YrzwVafWm%2B%2BctXBPe_Rb1YqeOKjjA%40mail.gmail.com

Regards,
Tatsuro Yamada