Viewing extensions
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.
Get PostgreSQL Server Programming - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
