Re: Catalog domain not-null constraints - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Catalog domain not-null constraints
Date
Msg-id 202403260730.cprszamfv5rx@alvherre.pgsql
Whole thread Raw
In response to Re: Catalog domain not-null constraints  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: Catalog domain not-null constraints
List pgsql-hackers
On 2024-Mar-25, Dean Rasheed wrote:

> Also (not this patch's fault), psql doesn't seem to offer a way to
> display domain constraint names -- something you need to know to drop
> or alter them. Perhaps \dD+ could be made to do that?

Ooh, I remember we had offered a patch for \d++ to display these
constraint names for tables, but didn't get around to gather consensus
for it.  We did gather consensus on *not* wanting \d+ to display them,
but we need *something*.  I suppose we should do something symmetrical
for tables and domains.  How about \dD++ and \dt++?

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
Bob [Floyd] used to say that he was planning to get a Ph.D. by the "green
stamp method," namely by saving envelopes addressed to him as 'Dr. Floyd'.
After collecting 500 such letters, he mused, a university somewhere in
Arizona would probably grant him a degree.              (Don Knuth)



pgsql-hackers by date:

Previous
From: Yasuo Honda
Date:
Subject: Re: pg_stat_statements and "IN" conditions
Next
From: Peter Eisentraut
Date:
Subject: Re: make dist using git archive