一、安装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

四、参考