pg_available_extensions — PostgreSQL system view

Summary

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.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_available_extensions system view exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

• 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 GUC then the full path will be shown. Only superusers can see this information.
• comment text
  Comment string from the extension’s control file

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

• PostgreSQL system catalog & view index
• Built-in function reference

Reference: PostgreSQL documentation — pg_available_extensions.