Horton

Improvements to psql \dAo and \dAp commands

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: 8d2ed66e4107ef27d05aef682c68af5952af7690
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2020-07-13T15:53:20Z
Releases: 14.0 
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

Files

PathChange+/−
src/bin/psql/command.c modified +1 −1
src/bin/psql/describe.c modified +46 −47
src/bin/psql/describe.h modified +1 −1
src/test/regress/expected/psql.out modified +49 −49
src/test/regress/sql/psql.sql modified +1 −1

Discussion