PG_AVAILABLE_EXTENSIONS

PG_AVAILABLE_EXTENSIONS displays extended information about certain database features.

Table 1 PG_AVAILABLE_EXTENSIONS columns

Name	Type	Description
name	name	Extension name
default_version	text	Name of the default version (NULL if none is specified)
installed_version	text	Currently installed version of the extension (NULL if no version is installed)
comment	text	Comment string from the extension's control file