Re: Add psql command to list constraints

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(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>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Add psql command to list constraints
Date: 2022-03-25 19:24:34
Message-ID: CA+TgmoY_hcPJ6u6bjp5pfQUtQYzH92Ti-na=jEopwORhfLZJOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 25, 2022 at 3:20 PM Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
> \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.

I don't think that \dX is comparable, because I don't think we should
regard extended statistics as a table object. Indeed, generalizing
extended statistics so that they can be generated on a join seems to
me to be one of the most important things we could do in that area.

--
Robert Haas
EDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2022-03-25 19:32:23 Re: [PATCH] Enable SSL library detection via PQsslAttribute
Previous Message Robert Haas 2022-03-25 19:22:50 Re: Add non-blocking version of PQcancel