| Postgres-XC 1.2devel Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 47. System Catalogs | Fast Forward | Next |
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
| Name | Type | Description |
|---|---|---|
| name | name | Extension name |
| default_version | text | Name of default version, or NULL if none is specified |
| installed_version | text | Currently installed version of the extension, or NULL if not installed |
| comment | text | Comment string from the extension's control file |
The pg_available_extensions view is read only.