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

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: Tatsuro Yamada <yamatattsu(at)gmail(dot)com>
Cc: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] psql: add \dcs to list all constraints
Date: 2026-01-19 13:09:48
Message-ID: 202601191308.7tlkwng3qcpy@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2026-Jan-19, Tatsuro Yamada wrote:

Hello,

> # Summary
> The following changes are planned for the next patch:
>
> - Changed the query (using UNION ALL)
> - Changed the columns and their order (and the sort order accordingly):
> - Schema | Table | Type | Name | Definition
> - Toggle definition verbosity with the + option
> - Added a test case: \dCN cust*.order*
>
> The following items will not be included for now (as they are not critical):
>
> - Option to switch sort order
> (e.g., sort by constraint name vs. table name)
> - Improved command name checking logic

Yeah, that sounds good to me.

Thanks!

--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"No deja de ser humillante para una persona de ingenio saber
que no hay tonto que no le pueda enseñar algo." (Jean B. Say)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2026-01-19 13:30:48 Re: pg_waldump: support decoding of WAL inside tarfile
Previous Message vignesh C 2026-01-19 13:06:34 Re: Logical Replication of sequences