47.57. pg_available_extensions

Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly. You can read PostgreSQL as Postgres-XC except for version number, which is specific to each product.

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 47-58. pg_available_extensions Columns

NameTypeDescription
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's control file

The pg_available_extensions view is read only.