pg_available_extension_versions 是一个 系统目录 视图，列出所有可用的 扩展 版本。
pg_available_extension_versions 在 PostgreSQL 9.1 中添加。
按PostgreSQL版本定义
pg_available_extension_versions (PostgreSQL 17)
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 | | |
pg_available_extension_versions (PostgreSQL 16)
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 | | |
pg_available_extension_versions (PostgreSQL 15)
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 | | |
pg_available_extension_versions (PostgreSQL 14)
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 | | |
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 | | |
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 | | |
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 | | |
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 | | |
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 |
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 |
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 |
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 |
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 |
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 |
更改历史记录
- PostgreSQL 13
- 添加列
trusted(提交 50fc694e)
- 添加列
- PostgreSQL 9.1
- 添加 (提交 d9572c4e)
示例
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)
参考文献
- PostgreSQL 文档： pg_available_extension_versions