---
title: "pg_available_extension_versions"
id: view-pg-available-extension-versions
pg_version: "20devel"
---

<a id="view-pg-available-extension-versions"></a>

## 53.4. pg_available_extension_versions

The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the [pg_extension](catalog-pg-extension.md) catalog, which shows the extensions currently installed. 

**pg_available_extension_versions Columns**

| Column Type | Description | 
| --- | --- |
| `name` `name` | Extension name |
| `version` `text` | Version name |
| `installed` `bool` | True if this version of this extension is currently installed |
| `superuser` `bool` | True if only superusers are allowed to install this extension (but see `trusted`) |
| `trusted` `bool` | True if the extension can be installed by non-superusers with appropriate privileges |
| `relocatable` `bool` | True if extension can be relocated to another schema |
| `schema` `name` | Name of the schema that the extension must be installed into, or `NULL` if partially or fully relocatable |
| `requires` `name[]` | Names of prerequisite extensions, or `NULL` if none |
| `location` `text` | The location where the extension is installed. If it is in the standard system location, then the value will be `$system`, while if it is found in the path specified by the [extension_control_path](runtime-config-client.md#guc-extension-control-path) GUC then the full path will be shown. Only superusers can see this information. |
| `comment` `text` | Comment string from the extension's control file |

The pg_available_extension_versions view is read-only.