pg_available_extension_versions

A system catalogue view listing all available extensions versions

pg_available_extension_versions is a system catalogue view listing all available extension versions.

pg_available_extension_versions was introduced in PostgreSQL 9.1.

Definition by PostgreSQL version

pg_available_extension_versions (PostgreSQL 13)

   View "pg_catalog.pg_available_extension_versions"
   Column    |  Type   | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
 name        | name    |           |          |
 version     | text    |           |          |
 installed   | boolean |           |          |
 superuser   | boolean |           |          |
 trusted     | boolean |           |          |
 relocatable | boolean |           |          |
 schema      | name    |           |          |
 requires    | name[]  |           |          |
 comment     | text    |           |          |
    

Documentation: pg_available_extension_versions

pg_available_extension_versions (PostgreSQL 12)

   View "pg_catalog.pg_available_extension_versions"
   Column    |  Type   | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
 name        | name    |           |          |
 version     | text    |           |          |
 installed   | boolean |           |          |
 superuser   | boolean |           |          |
 relocatable | boolean |           |          |
 schema      | name    |           |          |
 requires    | name[]  |           |          |
 comment     | text    |           |          |
    

Documentation: pg_available_extension_versions

pg_available_extension_versions (PostgreSQL 11)

   View "pg_catalog.pg_available_extension_versions"
   Column    |  Type   | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
 name        | name    |           |          |
 version     | text    |           |          |
 installed   | boolean |           |          |
 superuser   | boolean |           |          |
 relocatable | boolean |           |          |
 schema      | name    |           |          |
 requires    | name[]  |           |          |
 comment     | text    |           |          |
    

Documentation: pg_available_extension_versions

pg_available_extension_versions (PostgreSQL 10)

   View "pg_catalog.pg_available_extension_versions"
   Column    |  Type   | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
 name        | name    |           |          |
 version     | text    |           |          |
 installed   | boolean |           |          |
 superuser   | boolean |           |          |
 relocatable | boolean |           |          |
 schema      | name    |           |          |
 requires    | name[]  |           |          |
 comment     | text    |           |          |
    

Documentation: pg_available_extension_versions

pg_available_extension_versions (PostgreSQL 9.6)

View "pg_catalog.pg_available_extension_versions"
   Column    |  Type   | Modifiers
-------------+---------+-----------
 name        | name    |
 version     | text    |
 installed   | boolean |
 superuser   | boolean |
 relocatable | boolean |
 schema      | name    |
 requires    | name[]  |
 comment     | text    |
    

Documentation: pg_available_extension_versions

pg_available_extension_versions (PostgreSQL 9.5)

View "pg_catalog.pg_available_extension_versions"
   Column    |  Type   | Modifiers
-------------+---------+-----------
 name        | name    |
 version     | text    |
 installed   | boolean |
 superuser   | boolean |
 relocatable | boolean |
 schema      | name    |
 requires    | name[]  |
 comment     | text    |
    

Documentation: pg_available_extension_versions

pg_available_extension_versions (PostgreSQL 9.4)

View "pg_catalog.pg_available_extension_versions"
   Column    |  Type   | Modifiers
-------------+---------+-----------
 name        | name    |
 version     | text    |
 installed   | boolean |
 superuser   | boolean |
 relocatable | boolean |
 schema      | name    |
 requires    | name[]  |
 comment     | text    |
    

Documentation: pg_available_extension_versions

pg_available_extension_versions (PostgreSQL 9.3)

View "pg_catalog.pg_available_extension_versions"
   Column    |  Type   | Modifiers
-------------+---------+-----------
 name        | name    |
 version     | text    |
 installed   | boolean |
 superuser   | boolean |
 relocatable | boolean |
 schema      | name    |
 requires    | name[]  |
 comment     | text    |
    

Documentation: pg_available_extension_versions

pg_available_extension_versions (PostgreSQL 9.2)

View "pg_catalog.pg_available_extension_versions"
   Column    |  Type   | Modifiers
-------------+---------+-----------
 name        | name    |
 version     | text    |
 installed   | boolean |
 superuser   | boolean |
 relocatable | boolean |
 schema      | name    |
 requires    | name[]  |
 comment     | text    |
    

Documentation: pg_available_extension_versions

pg_available_extension_versions (PostgreSQL 9.1)

View "pg_catalog.pg_available_extension_versions"
   Column    |  Type   | Modifiers
-------------+---------+-----------
 name        | name    |
 version     | text    |
 installed   | boolean |
 superuser   | boolean |
 relocatable | boolean |
 schema      | name    |
 requires    | name[]  |
 comment     | text    |
    

Documentation: pg_available_extension_versions

Change history

Examples

postgres=# SELECT * FROM pg_available_extension_versions WHERE name LIKE 'p%';
        name        | version | installed | superuser | relocatable |   schema   | requires |                              comment                              
--------------------+---------+-----------+-----------+-------------+------------+----------+-------------------------------------------------------------------
 pg_trgm            | 1.3     | f         | t         | t           |            |          | text similarity measurement and index searching based on trigrams
 pg_trgm            | 1.4     | f         | t         | t           |            |          | text similarity measurement and index searching based on trigrams
 plpgsql            | 1.0     | t         | f         | f           | pg_catalog |          | PL/pgSQL procedural language
 plperl             | 1.0     | f         | f         | f           | pg_catalog |          | PL/Perl procedural language
 pg_prewarm         | 1.1     | f         | t         | t           |            |          | prewarm relation data
 pg_prewarm         | 1.2     | f         | t         | t           |            |          | prewarm relation data
 pg_freespacemap    | 1.1     | f         | t         | t           |            |          | examine the free space map (FSM)
 pg_freespacemap    | 1.2     | f         | t         | t           |            |          | examine the free space map (FSM)
 pgstattuple        | 1.4     | f         | t         | t           |            |          | show tuple-level statistics
 pgstattuple        | 1.5     | f         | t         | t           |            |          | show tuple-level statistics
 postgres_fdw       | 1.0     | f         | t         | t           |            |          | foreign-data wrapper for remote PostgreSQL servers
 pgrowlocks         | 1.2     | f         | t         | t           |            |          | show row-level locking information
 pg_stat_statements | 1.4     | f         | t         | t           |            |          | track execution statistics of all SQL statements executed
 pg_stat_statements | 1.5     | f         | t         | t           |            |          | track execution statistics of all SQL statements executed
 pg_stat_statements | 1.6     | f         | t         | t           |            |          | track execution statistics of all SQL statements executed
 pgcrypto           | 1.3     | f         | t         | t           |            |          | cryptographic functions
 pg_buffercache     | 1.2     | f         | t         | t           |            |          | examine the shared buffer cache
 pg_buffercache     | 1.3     | f         | t         | t           |            |          | examine the shared buffer cache
 plperlu            | 1.0     | f         | t         | f           | pg_catalog |          | PL/PerlU untrusted procedural language
 pageinspect        | 1.5     | f         | t         | t           |            |          | inspect the contents of database pages at a low level
 pageinspect        | 1.6     | f         | t         | t           |            |          | inspect the contents of database pages at a low level
 pageinspect        | 1.7     | f         | t         | t           |            |          | inspect the contents of database pages at a low level
 pg_visibility      | 1.1     | f         | t         | t           |            |          | examine the visibility map (VM) and page-level visibility info
 pg_visibility      | 1.2     | f         | t         | t           |            |          | examine the visibility map (VM) and page-level visibility info
(24 rows)

Categories

Extension, System catalogue

See also

Extension, pg_available_extensions, pg_extension