Improvements to psql \dAo and \dAp commands
authorAlexander Korotkov <akorotkov@postgresql.org>
Sat, 11 Jul 2020 11:14:49 +0000 (14:14 +0300)
committerAlexander Korotkov <akorotkov@postgresql.org>
Mon, 13 Jul 2020 15:53:13 +0000 (18:53 +0300)
commitae290059e1aa5bc2272a0345184bcf05407f69a4
tree7ab32e40eedc156abbe485a41ce64c06b647d34b
parentd8a7ce245095e3a70a2ad738c17be95593f68996
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
src/bin/psql/command.c
src/bin/psql/describe.c
src/bin/psql/describe.h
src/test/regress/expected/psql.out
src/test/regress/sql/psql.sql