Querying the pg_extension
system view or using the meta-command \dx
will show the extensions currently installed in the database.
postgres=# \dx List of installed extensions -[ RECORD 1 ]----------------------------- Name | pgcrypto Version | 1.0 Schema | public Description | cryptographic functions -[ RECORD 2 ]----------------------------- Name | plperl Version | 1.0 Schema | pg_catalog Description | PL/Perl procedural language -[ RECORD 3 ]----------------------------- Name | plpgsql Version | 1.0 Schema | pg_catalog Description | PL/pgSQL procedural language
The extensions that are ready to be installed can be viewed from the pg_available_extensions
or pg_available_extension_versions
system views.