pgsql: Improvements to psql \dAo and \dAp commands

From: Alexander Korotkov <akorotkov(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Improvements to psql \dAo and \dAp commands
Date: 2020-07-13 15:57:59
Message-ID: E1jv0q7-0002s8-4w@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Improvements to psql \dAo and \dAp commands

* Strategy number and purpose are essential information for opfamily operator.
So, show those columns in non-verbose output.
* "Left/right arg type" \dAp column names are confusing, because those type
don't necessary match to function arguments. Rename them to "Registered
left/right type".
* Replace manual assembling of operator/procedure names with casts to
regoperator/regprocedure.
* Add schema-qualification for pg_catalog functions and tables.

Reported-by: Peter Eisentraut, Tom Lane
Reviewed-by: Tom Lane
Discussion: https://postgr.es/m/2edc7b27-031f-b2b6-0db2-864241c91cb9%402ndquadrant.com
Backpatch-through: 13

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/ae290059e1aa5bc2272a0345184bcf05407f69a4

Modified Files
--------------
src/bin/psql/command.c | 2 +-
src/bin/psql/describe.c | 93 ++++++++++++++++++------------------
src/bin/psql/describe.h | 2 +-
src/test/regress/expected/psql.out | 98 +++++++++++++++++++-------------------
src/test/regress/sql/psql.sql | 2 +-
5 files changed, 98 insertions(+), 99 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2020-07-13 15:58:31 pgsql: Fix bugs in libpq's management of GSS encryption state.
Previous Message Alexander Korotkov 2020-07-13 15:57:51 pgsql: Improvements to psql \dAo and \dAp commands