> pg_available_extension_versions視圖列出了可用于安裝的指定擴展版本 | 列 | 類型 | 描述 | | --- | --- | --- | | name | name | 擴展名 | | version | text | 默認版本 | | installed | bool | 如果此版本的擴展當前已安裝則為真 | | superuser | bool | 如果只有超級用戶被允許安裝此擴展則為真(更多請參見`trusted`) | | trusted | bool | 如果擴展可以由具有適當權限的非超級用戶安裝，則為真 | | relocatable | bool | 如果擴展能被重定位到另一個模式則為真 | | schema |name| 此擴展必須被安裝到的模式名，如果此擴展是部分或者全部可以重定位的，此列為`NULL` | | requires | name[] | 要引入的擴展名稱，沒有則為NULL | | comment | text | 擴展的控制文件的注釋字符串 | ``` postgres=# select * from pg_available_extension_versions; name | version | installed | superuser | trusted | relocatable | schema | requires | comment --------------------+---------+-----------+-----------+---------+-------------+------------+----------+------------------------------------------------------------------------ pg_stat_statements | 1.4 | f | t | f | t | | | track planning and execution statistics of all SQL statements executed pg_stat_statements | 1.5 | f | t | f | t | | | track planning and execution statistics of all SQL statements executed pg_stat_statements | 1.6 | f | t | f | t | | | track planning and execution statistics of all SQL statements executed pg_stat_statements | 1.7 | f | t | f | t | | | track planning and execution statistics of all SQL statements executed pg_stat_statements | 1.8 | t | t | f | t | | | track planning and execution statistics of all SQL statements executed first_last_agg | 0.1.4 | t | t | f | t | | | first() and last() aggregate functions plpgsql | 1.0 | t | t | t | f | pg_catalog | | PL/pgSQL procedural language pg_freespacemap | 1.1 | f | t | f | t | | | examine the free space map (FSM) pg_freespacemap | 1.2 | t | t | f | t | | | examine the free space map (FSM) pg_visibility | 1.1 | f | t | f | t | | | examine the visibility map (VM) and page-level visibility info pg_visibility | 1.2 | t | t | f | t | | | examine the visibility map (VM) and page-level visibility info plpython2u | 1.0 | f | t | f | f | pg_catalog | | PL/Python2U untrusted procedural language plperl | 1.0 | f | t | t | f | pg_catalog | | PL/Perl procedural language demo | 1.0 | t | t | f | f | | | A key/value pair data type plperlu | 1.0 | f | t | f | f | pg_catalog | | PL/PerlU untrusted procedural language pg_trgm | 1.3 | f | t | t | t | | | text similarity measurement and index searching based on trigrams pg_trgm | 1.4 | f | t | t | t | | | text similarity measurement and index searching based on trigrams pg_trgm | 1.5 | t | t | t | t | | | text similarity measurement and index searching based on trigrams plpythonu | 1.0 | f | t | f | f | pg_catalog | | PL/PythonU untrusted procedural language (19 rows) ```