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

postgresql psql postgresql-extensions
ARV picture ARV · Feb 15, 2014 · Viewed 137.8k times · Source

How do I list all extensions that are already installed in a database or schema from psql?

See also

Answer

a_horse_with_no_name picture a_horse_with_no_name · Feb 15, 2014

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

Related questions

PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More
Run a PostgreSQL .sql file using command line arguments

I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my PostgreSQL database in order to add them to a table. The files are that large that it is impossible to …

Read More
How to switch databases in psql?

In MySQL, I used use database_name; What's the psql equivalent?

Read More