PostgreSQL Extension管理
一、安装Extension
- snippet.sql
tpch1s=# CREATE extension gp_internal_tools; CREATE EXTENSION
二、查询Extension
查看已安装Extension
- snippet.sql
tpch1s=# \dx List OF installed extensions Name | Version | Schema | Description -------------------+---------+------------+--------------------------------------------------- plpgsql | 1.0 | pg_catalog | PL/pgSQL PROCEDURAL LANGUAGE
查看所有Extension扩展
- snippet.sql
tpch1s=# SELECT * FROM pg_available_extensions; name | default_version | installed_version | comment ------------------------+-----------------+-------------------+-------------------------------------------------------------- plpythonu | 1.0 | | PL/PythonU untrusted PROCEDURAL LANGUAGE citext | 1.3 | | DATA TYPE FOR case-insensitive CHARACTER strings file_fdw | 1.0 | | foreign-DATA wrapper FOR flat file access fuzzystrmatch | 1.1 | | determine similarities AND distance BETWEEN strings ……
三、删除Extension
- snippet.sql
tpch1s=# DROP extension gp_internal_tools; DROP EXTENSION
四、参考
打赏作者以资鼓励：
 |  |