> pg_available_extensions視圖列出了可用于安裝的擴展 | 列 | 類型 | 描述 | | --- | --- | --- | | name | name | 擴展名 | | default_version | text | 默認版本 | | installed_version | text | 當前已安裝的擴展版本，如果沒有安裝則為NULL | | comment | text | 擴展的控制文件的注釋字符串 | ``` postgres=# SELECT * from pg_available_extensions; name | default_version | installed_version | comment --------------------+-----------------+-------------------+------------------------------------------------------------------------ pg_stat_statements | 1.8 | 1.8 | track planning and execution statistics of all SQL statements executed first_last_agg | 0.1.4 | 0.1.4 | first() and last() aggregate functions plpgsql | 1.0 | 1.0 | PL/pgSQL procedural language pg_freespacemap | 1.2 | 1.2 | examine the free space map (FSM) pg_visibility | 1.2 | 1.2 | examine the visibility map (VM) and page-level visibility info plpython2u | 1.0 | | PL/Python2U untrusted procedural language plperl | 1.0 | | PL/Perl procedural language demo | 1.0 | 1.0 | A key/value pair data type plperlu | 1.0 | | PL/PerlU untrusted procedural language pg_trgm | 1.5 | 1.5 | text similarity measurement and index searching based on trigrams plpythonu | 1.0 | | PL/PythonU untrusted procedural language (11 rows) ```