Wiki / psql Commands / Describe database objects
\dAf
Lists operator families (see Section 36.16.5 ). If access-method-pattern is specified, only operator families associated with access methods whose names match that pattern are listed. If input-type-pattern is specified, only operator families associ…
Reading PostgreSQL 18.6.
Description
Lists operator families (see Section 36.16.5 ). If access-method-pattern is specified, only operator families associated with access methods whose names match that pattern are listed. If input-type-pattern is specified, only operator families associated with input types 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 family is listed with its owner.
- Client
- psql 18.6
- Case-sensitive spelling
- \dAf
Usage
\dAf[x+] [ access-method-pattern [ input-type-pattern ]]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \dAf | x+ |
Manual definition
\dAf[x+] [access-method-pattern[input-type-pattern]]-
Lists operator families (see Section 36.16.5). If
access-method-patternis specified, only operator families associated with access methods whose names match that pattern are listed. Ifinput-type-patternis specified, only operator families associated with input types 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 family is listed with its owner.
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 12 → 13: added.
--- PostgreSQL 12
+++ PostgreSQL 13
@@ -1 +1,13 @@
-Not recorded in this version
+{
+ "definition": "Lists operator families (see Section 37.16.5 ). If access-method-pattern is specified, only operator families associated with access methods whose names match that pattern are listed. If input-type-pattern is specified, only operator families associated with input types whose names match that pattern are listed. If + is appended to the command name, each operator family is listed with its owner.",
+ "modifiers": [
+ {
+ "command": "\\dAf",
+ "modifiers": "+"
+ }
+ ],
+ "signature": "\\dAf[+] [ access-method-pattern [ input-type-pattern ]]",
+ "spellings": [
+ "\\dAf"
+ ]
+}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.