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

Tatsuro Yamada <yamatattsu@gmail.com>

View thread View on postgr.es

From: Tatsuro Yamada <yamatattsu@gmail.com>

To: Jim Jones <jim.jones@uni-muenster.de>

Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, Álvaro Herrera <alvherre@kurilemu.de>

Date: 2026-01-12T05:39:21Z

Lists: pgsql-hackers

Attachments

0001-Add-list-constraints-meta-command-dcs-on-psql_r2.patch (application/x-patch) patch 0001

Hi,

On Sat, Jan 10, 2026 at 12:14 PM Tatsuro Yamada <yamatattsu@gmail.com>
wrote:

> The next patch will include the following:
> - Rebased version
> - Expanded regression tests (kept to a minimum)
>

I revised the patch based on my previous email.

It includes:
  - Rebased version
  - Cosmetic changes
  - Add incorrect option check
  - Use validateSQLNamePattern() instead of processSQLNamePattern()
  - Fix bug \dcs with 'x' (expanded display) option
  - Add table name into ORDER BY to get consistent results
  - Add regression test cases
    - some edge cases suggested by Jim (Thanks!)
    - test cases for using validateSQLNamePattern()
    - incorrect option check, and so on

Comments and suggestions are welcome.

Regards,
Tatsuro Yamada