Re: Add psql command to list constraints

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Greg Stark <stark(at)mit(dot)edu>, Dag Lem <dag(at)nimrod(dot)no>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Tatsuro Yamada <tatsuro(dot)yamada(dot)tf(at)nttcom(dot)co(dot)jp>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add psql command to list constraints
Date: 2022-03-25 19:20:25
Message-ID: 20220325192024.GF28503@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 25, 2022 at 03:11:47PM -0400, Robert Haas wrote:
> On Fri, Mar 25, 2022 at 12:28 AM Greg Stark <stark(at)mit(dot)edu> wrote:
> > Development of this seems to have stalled with the only review of this
> > patch expressing some skepticism about whether it's needed at all.
>
> Now, there is some precedent for the idea of providing a command that
> lists everything globally. Specifically, we have a \dp command, also
> known as \z, to list privileges across all objects in the database.

> The other thing that we have that is somewhat similar to this is \dd,

\dX is similar, and I remember wondering whether it was really useful/needed.
The catalog tables are exposed and documented for a reason, and power-users
will learn to use them.

+0.5 to mark the patch as RWF or rejected.

--
Justin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2022-03-25 19:22:50 Re: Add non-blocking version of PQcancel
Previous Message Robert Haas 2022-03-25 19:11:47 Re: Add psql command to list constraints