---
title: "pg_available_extensions"
id: view-pg-available-extensions
pg_version: "20devel"
---

<a id="view-pg-available-extensions"></a>

## 53.3. pg_available_extensions

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

**pg_available_extensions Columns**

| Column 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 |
| `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_extensions view is read-only.