The pg_available_extension_versions view lists the specific extension versions that are available for installation. The pg_extension system catalog table shows the extensions currently installed.

    The view is read only.

    columntypedescription
    namenameExtension name.
    versiontextVersion name.
    installedbooleanTrue if this version of this extension is currently installed, False otherwise.
    superuserbooleanTrue if only superusers are allowed to install the extension, False otherwise.
    relocatablebooleanTrue if extension can be relocated to another schema, False otherwise.
    schemanameName of the schema that the extension must be installed into, or NULL if partially or fully relocatable.
    requiresname[]Names of prerequisite extensions, or NULL if none
    commenttextComment string from the extension control file.

    Parent topic: System Catalogs Definitions