SyntaxFix

[postgresql] Using psql how do I list extensions installed in a database?

In psql that would be

\dx

See the manual for details: http://www.postgresql.org/docs/current/static/app-psql.html

Doing it in plain SQL it would be a select on pg_extension: 

SELECT * 
FROM pg_extension

http://www.postgresql.org/docs/current/static/catalog-pg-extension.html

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside

Examples related to psql

• The Response content must be a string or object implementing __toString(), "boolean" given after move to psql • psql: command not found Mac • How to select a schema in postgres when using psql? • "psql: could not connect to server: Connection refused" Error when connecting to remote database • PostgreSQL: Why psql can't connect to server? • How to show data in a table by using psql command line interface? • Using psql how do I list extensions installed in a database? • psql: FATAL: database "<user>" does not exist • List tables in a PostgreSQL schema • postgresql port confusion 5433 or 5432?

Examples related to postgresql-extensions

• Using psql how do I list extensions installed in a database?