| 命令 | 詳解 | | --- | --- | | CREATE EXTENSION IF NOT EXISTS 擴展名; | 安裝擴展 | |DROP EXTENSION 擴展名| 刪除擴展| |select * from pg_extension| 查看已安裝的擴展| |select * from pg_available_extensions| 查看可安裝的擴展| |select * from pg_available_extension_versions| 查看可安裝的指定版本的擴展| |\dx[+]| 命令行下查看已安裝擴展 | ``` postgres=# \dx List of installed extensions Name | Version | Schema | Description -----------------+---------+------------+------------------------------------------------------------------- first_last_agg | 0.1.4 | public | first() and last() aggregate functions pg_freespacemap | 1.2 | public | examine the free space map (FSM) pg_trgm | 1.5 | public | text similarity measurement and index searching based on trigrams pg_visibility | 1.2 | public | examine the visibility map (VM) and page-level visibility info plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language (5 rows) postgres=# select * from pg_extension; oid | extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition -------+-----------------+----------+--------------+----------------+------------+-----------+-------------- 13566 | plpgsql | 10 | 11 | f | 1.0 | | 16439 | first_last_agg | 10 | 2200 | t | 0.1.4 | | 16446 | pg_trgm | 10 | 2200 | t | 1.5 | | 16540 | pg_freespacemap | 10 | 2200 | t | 1.2 | | 16555 | pg_visibility | 10 | 2200 | t | 1.2 | | (5 rows) ```