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

From: Tatsuro Yamada <yamatattsu(at)gmail(dot)com>
To: Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Subject: Re: [PATCH] psql: add \dcs to list all constraints
Date: 2026-01-12 05:39:21
Message-ID: CAOKkKFscV6pHM1_cFUSAC+E-A03sWsLZQq0XW-ZCs-6=iWJGzg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Sat, Jan 10, 2026 at 12:14 PM Tatsuro Yamada <yamatattsu(at)gmail(dot)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

Attachment Content-Type Size
0001-Add-list-constraints-meta-command-dcs-on-psql_r2.patch application/x-patch 34.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2026-01-12 05:51:26 Re: docs: clarify ALTER TABLE behavior on partitioned tables
Previous Message li carol 2026-01-12 05:36:15 RE: Use correct macro for accessing offset numbers.