pg_available_extensions
The pg_available_extensions view lists the extensions that are available for installation. See also the pg_extension catalog, which shows the extensions currently installed.
Table pg_available_extensions Columns
| Column Type Description | 
|---|
 Extension name  | 
 Name of default version, or   | 
 Currently installed version of the extension, or   | 
 Comment string from the extension's control file  | 
The pg_available_extensions view is read-only.