Wiki / psql Commands / Describe database objects
\dAp
Lists support functions associated with operator families (see Section 36.16.3 ). If access-method-pattern is specified, only functions of operator families associated with access methods whose names match that pattern are listed. If operator-family…
Reading PostgreSQL 18.6.
Description
Lists support functions associated with operator families (see Section 36.16.3 ). If access-method-pattern is specified, only functions of operator families associated with access methods whose names match that pattern are listed. If operator-family-pattern is specified, only functions 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, functions are displayed verbosely, with their actual parameter lists.
- Client
- psql 18.6
- Case-sensitive spelling
- \dAp
Usage
\dAp[x+] [ access-method-pattern [ operator-family-pattern ]]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \dAp | x+ |
Manual definition
\dAp[x+] [access-method-pattern[operator-family-pattern]]-
Lists support functions associated with operator families (see Section 36.16.3). If
access-method-patternis specified, only functions of operator families associated with access methods whose names match that pattern are listed. Ifoperator-family-patternis specified, only functions 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, functions are displayed verbosely, with their actual parameter lists.
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 16 → 17: changed.
--- PostgreSQL 16
+++ PostgreSQL 17
@@ -1,5 +1,5 @@
{
- "definition": "Lists support functions associated with operator families (see Section 38.16.3 ). If access-method-pattern is specified, only functions of operator families associated with access methods whose names match that pattern are listed. If operator-family-pattern is specified, only functions of operator families whose names match that pattern are listed. If + is appended to the command name, functions are displayed verbosely, with their actual parameter lists.",
+ "definition": "Lists support functions associated with operator families (see Section 36.16.3 ). If access-method-pattern is specified, only functions of operator families associated with access methods whose names match that pattern are listed. If operator-family-pattern is specified, only functions of operator families whose names match that pattern are listed. If + is appended to the command name, functions are displayed verbosely, with their actual parameter lists.",
"modifiers": [
{
"command": "\\dAp",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.