Wiki / psql Commands / Describe database objects
\dx
Lists installed extensions. If pattern is specified, only those extensions whose names match the 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, all the obje…
Reading PostgreSQL 18.6.
Description
Lists installed extensions. If pattern is specified, only those extensions whose names match the 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, all the objects belonging to each matching extension are listed.
- Client
- psql 18.6
- Case-sensitive spelling
- \dx
Usage
\dx[x+] [ pattern ]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \dx | x+ |
Manual definition
\dx[x+] [pattern]-
Lists installed extensions. If
patternis specified, only those extensions whose names match the pattern are listed. Ifxis appended to the command name, the results are displayed in expanded mode. If+is appended to the command name, all the objects belonging to each matching extension are listed.
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 installed extensions. If pattern is specified, only those extensions whose names match the pattern are listed. If the form \\dx+ is used, all the objects belonging to each matching extension are listed.",
+ "definition": "Lists installed extensions. If pattern is specified, only those extensions whose names match the 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, all the objects belonging to each matching extension are listed.",
"modifiers": [
{
"command": "\\dx",
- "modifiers": "+"
+ "modifiers": "x+"
}
],
- "signature": "\\dx[+] [ pattern ]",
+ "signature": "\\dx[x+] [ pattern ]",
"spellings": [
"\\dx"
]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.