From b0b5e20cd8d1a58a8782d5dc806a5232db116e2f Mon Sep 17 00:00:00 2001 From: Alexander Korotkov Date: Sun, 8 Mar 2020 13:32:25 +0300 Subject: Show opclass and opfamily related information in psql This commit provides psql commands for listing operator classes, operator families and its contents in psql. New commands will be useful for exploring capabilities of both builtin opclasses/opfamilies as well as opclasses/opfamilies defined in extensions. Discussion: https://postgr.es/m/1529675324.14193.5.camel%40postgrespro.ru Author: Sergey Cherkashin, Nikita Glukhov, Alexander Korotkov Reviewed-by: Michael Paquier, Alvaro Herrera, Arthur Zakirov Reviewed-by: Kyotaro Horiguchi, Andres Freund --- doc/src/sgml/ref/psql-ref.sgml | 91 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 91 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 20ba1051606..67ecec27cf9 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1231,6 +1231,97 @@ testdb=> + + + \dAc[+] + [access-method-pattern + [input-type-pattern]] + + + + + Lists operator classes + (see ). + If access-method-patttern + is specified, only operator classes associated with access methods whose + names match pattern are listed. + If input-type-pattern + is specified, only operator classes associated with input types whose + names match the pattern are listed. + If + is appended to the command name, each operator + class is listed with its associated operator family and owner. + + + + + + + \dAf[+] + [access-method-pattern + [input-type-pattern]] + + + + + Lists operator families + (see ). + If access-method-patttern + is specified, only operator families associated with access methods whose + names match pattern are listed. + If input-type-pattern + is specified, only operator families associated with input types whose + names match the pattern are listed. + If + is appended to the command name, each operator + family is listed with its owner. + + + + + + + \dAo[+] + [access-method-pattern + [operator-family-pattern]] + + + + + + Lists operators associated with operator families + (). + If access-method-patttern + is specified, only members of operator families associated with access + methods whose names match pattern are listed. + If input-type-pattern + is specified, only memeber of operator families whose names match the + pattern are listed. + If + is appended to the command name, each operator + is listed with its strategy number, purpose and sort operator family. + + + + + + + \dAp[+] + [access-method-pattern + [operator-family-pattern]] + + + + + Lists procedures associated with operator families + (). + If access-method-patttern + is specified, only members of operator families associated with access + methods whose names match pattern are listed. + If input-type-pattern + is specified, only memeber of operator families whose names match the + pattern are listed. + + + + \db[+] [ pattern ] -- cgit v1.2.3