PostgreSQL offers various views so that we can figure out which extensions are on the system and which ones are actually deployed. One of those views is pg_available_extensions:
test=# \d pg_available_extensions View "pg_catalog.pg_available_extensions" Column | Type | Collation | Nullable | Default ------------------+-------+-----------+----------+--------- name | name | | | default_version | text | | | installed_version | text | C | | comment | text | | |
This contains a list of all of the extensions that are available, including their names, their default version, and the version that's currently installed. To make this easier for the end user, there is also a description available, telling us more ...
