PostgreSQL Cheat Sheet/List installed extensions

Show installed extensions and versions.

Section: Views, Functions, Triggers, and Extensions

List installed extensions

sql
sql
\dx
Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Views, Functions, Triggers, and Extensions
List databases
Show all databases in the cluster.
OpenIn sheetsql2 tag match
Connect to a database
Open an interactive psql session to a database.
OpenIn sheetbash1 tag match
Connect with URI
Connect using a full PostgreSQL connection string.
OpenIn sheetbash1 tag match
List roles
Show roles and memberships.
OpenIn sheetsql1 tag match
List schemas
Show schemas in the current database.
OpenIn sheetsql1 tag match
List tables views and sequences
List relations across schemas.
OpenIn sheetsql1 tag match