pg_available_extensions

The pg_available_extensions view lists the extensions that are available for installation. The pg_extension system catalog table shows the extensions currently installed.

The view is read only.

columntypedescription
namenameExtension name.
default_versiontextName of default version, or NULL if none is specified.
installed_versiontextCurrently installed version of the extension, or NULL if not installed.
commenttextComment string from the extension control file.

Parent topic: System Catalogs Definitions