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:20 +0000 (18:53 +0300)
commit8d2ed66e4107ef27d05aef682c68af5952af7690
tree1981afade7535a078da866efa6af2c34ad813ba3
parent2302302236a0c7aeba3377d78dd9d80ba53247df
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