Using psql how do I list extensions installed in a

问题:

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

See also

• Finding a list of available extensions that PostgreSQL ships with

回答1:

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

回答2:

Additionally if you want to know which extensions are available on your server: SELECT * FROM pg_available_extensions