# 一、安装Extension

```sql
tpch1s=# create extension gp_internal_tools;
CREATE EXTENSION
```

# 二、查询Extension

## 查看已安装Extension

```sql
tpch1s=# \dx
                                 List of installed extensions
       Name        | Version |   Schema   |                    Description                    
-------------------+---------+------------+---------------------------------------------------
 plpgsql           | 1.0     | pg_catalog | PL/pgSQL procedural language

```

## 查看所有Extension扩展

```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

```sql
tpch1s=# drop extension gp_internal_tools;
DROP EXTENSION
```

# 四、参考

- [PostgreSQL之 使用扩展Extension](https://blog.csdn.net/pg_hgdb/article/details/79490509)