Wiki / psql Commands / Describe database objects
\dA
Lists access methods. If pattern is specified, only access methods whose names match the pattern are shown. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each access method is…
Reading PostgreSQL 18.6.
Description
Lists access methods. If pattern is specified, only access methods whose names match the pattern are shown. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each access method is listed with its associated handler function and description.
- Client
- psql 18.6
- Case-sensitive spelling
- \dA
Usage
\dA[x+] [ pattern ]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \dA | x+ |
Manual definition
\dA[x+] [pattern]-
Lists access methods. If
patternis specified, only access methods whose names match the pattern are shown. Ifxis appended to the command name, the results are displayed in expanded mode. If+is appended to the command name, each access method is listed with its associated handler function and description.
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 17 → 18: changed.
--- PostgreSQL 17
+++ PostgreSQL 18
@@ -1,12 +1,12 @@
{
- "definition": "Lists access methods. If pattern is specified, only access methods whose names match the pattern are shown. If + is appended to the command name, each access method is listed with its associated handler function and description.",
+ "definition": "Lists access methods. If pattern is specified, only access methods whose names match the pattern are shown. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each access method is listed with its associated handler function and description.",
"modifiers": [
{
"command": "\\dA",
- "modifiers": "+"
+ "modifiers": "x+"
}
],
- "signature": "\\dA[+] [ pattern ]",
+ "signature": "\\dA[x+] [ pattern ]",
"spellings": [
"\\dA"
]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 10 through 20; the first sample is not necessarily its introduction.