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