Wiki / psql Commands / Describe database objects
\dAo
Lists operators associated with operator families (see Section 36.16.2 ). If access-method-pattern is specified, only members of operator families associated with access methods whose names match that pattern are listed. If operator-family-pattern i…
Reading PostgreSQL 18.6.
Description
Lists operators associated with operator families (see Section 36.16.2 ). If access-method-pattern is specified, only members of operator families associated with access methods whose names match that pattern are listed. If operator-family-pattern is specified, only members of operator families whose names match that pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each operator is listed with its sort operator family (if it is an ordering operator), and whether its underlying function is leakproof.
- Client
- psql 18.6
- Case-sensitive spelling
- \dAo
Usage
\dAo[x+] [ access-method-pattern [ operator-family-pattern ]]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \dAo | x+ |
Manual definition
\dAo[x+] [access-method-pattern[operator-family-pattern]]-
Lists operators associated with operator families (see Section 36.16.2). If
access-method-patternis specified, only members of operator families associated with access methods whose names match that pattern are listed. Ifoperator-family-patternis specified, only members of operator families whose names match that pattern are listed. Ifxis appended to the command name, the results are displayed in expanded mode. If+is appended to the command name, each operator is listed with its sort operator family (if it is an ordering operator), and whether its underlying function is leakproof.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8
Compare versions
PostgreSQL 13 → 14: changed.
--- PostgreSQL 13
+++ PostgreSQL 14
@@ -1,5 +1,5 @@
{
- "definition": "Lists operators associated with operator families (see Section 37.16.2 ). If access-method-pattern is specified, only members of operator families associated with access methods whose names match that pattern are listed. If operator-family-pattern is specified, only members of operator families whose names match that pattern are listed. If + is appended to the command name, each operator is listed with its sort operator family (if it is an ordering operator).",
+ "definition": "Lists operators associated with operator families (see Section 38.16.2 ). If access-method-pattern is specified, only members of operator families associated with access methods whose names match that pattern are listed. If operator-family-pattern is specified, only members of operator families whose names match that pattern are listed. If + is appended to the command name, each operator is listed with its sort operator family (if it is an ordering operator).",
"modifiers": [
{
"command": "\\dAo",Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
Export JSON · Back to psql Commands · Recorded in PostgreSQL 13 through 20; the first sample is not necessarily its introduction.