Re: Add psql command to list constraints - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Add psql command to list constraints
Date
Msg-id CAKFQuwZDfEkcTx4svHh6D5n+ztroj9A_VLwsGEAA+khTqJZ7Gw@mail.gmail.com
Whole thread Raw
In response to Re: Add psql command to list constraints  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
On Monday, November 15, 2021, David G. Johnston <david.g.johnston@gmail.com> wrote:

If the only motivation for this is "feature completion" - since we have so many other \d commands already implemented - I say we should pass.

If anything, doing this for triggers would be a much better feature.

The other missing listing then would be columns.  I would rather add both columns and constraints, or neither.  And add triggers regardless as their combination of rarity and performance impact makes having them listable on a \d command would be beneficial.

I also noticed that the “\dd” command would need to be modified (and maybe deprecated if we actually do simply provide a listing for object type).

David J.
 

pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: Anything I can contribute?
Next
From: Michael Paquier
Date:
Subject: Re: pg_waldump stucks with options --follow or -f and --stats or -z