SHOW PLUGINS

功能描述

查看当前数据库中插件清单。

注意事项

N/A

语法格式

1. SHOW PLUGINS

参数说明

N/A

示例

1. --查看插件清单
2. openGauss=# SHOW PLUGINS;
3. Name       |  Status  | Type | Library | License |                      Comment
4. -----------------+----------+------+---------+---------+----------------------------------------------------
5. roach_api_stub  | DISABLED |      | NULL    |         | roach api stub
6. file_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for flat file access
7. security_plugin | ACTIVE   |      | NULL    |         | provides security functionality
8. hdfs_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for flat file access
9. plpgsql         | ACTIVE   |      | NULL    |         | PL/pgSQL procedural language
10. dolphin         | ACTIVE   |      | NULL    |         | sql engine
11. dist_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for distfs access
12. postgres_fdw    | DISABLED |      | NULL    |         | foreign-data wrapper for remote PostgreSQL servers
13. hstore          | ACTIVE   |      | NULL    |         | data type for storing sets of (key, value) pairs
14. log_fdw         | ACTIVE   |      | NULL    |         | Foreign Data Wrapper for accessing logging data

16. --插件状态的更新显示
17. openGauss=# drop Extension hstore;
18. openGauss=# SHOW PLUGINS;
19. Name       |  Status  | Type | Library | License |                      Comment
20. -----------------+----------+------+---------+---------+----------------------------------------------------
21. roach_api_stub  | DISABLED |      | NULL    |         | roach api stub
22. file_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for flat file access
23. security_plugin | ACTIVE   |      | NULL    |         | provides security functionality
24. hdfs_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for flat file access
25. plpgsql         | ACTIVE   |      | NULL    |         | PL/pgSQL procedural language
26. dolphin         | ACTIVE   |      | NULL    |         | sql engine
27. dist_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for distfs access
28. postgres_fdw    | DISABLED |      | NULL    |         | foreign-data wrapper for remote PostgreSQL servers
29. hstore          | DISABLED |      | NULL    |         | data type for storing sets of (key, value) pairs
30. log_fdw         | ACTIVE   |      | NULL    |         | Foreign Data Wrapper for accessing logging data

32. openGauss=# CREATE Extension hstore;
33. openGauss=# show plugins;
34. Name       |  Status  | Type | Library | License |                      Comment
35. -----------------+----------+------+---------+---------+----------------------------------------------------
36. roach_api_stub  | DISABLED |      | NULL    |         | roach api stub
37. file_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for flat file access
38. security_plugin | ACTIVE   |      | NULL    |         | provides security functionality
39. hdfs_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for flat file access
40. plpgsql         | ACTIVE   |      | NULL    |         | PL/pgSQL procedural language
41. dolphin         | ACTIVE   |      | NULL    |         | sql engine
42. dist_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for distfs access
43. postgres_fdw    | DISABLED |      | NULL    |         | foreign-data wrapper for remote PostgreSQL servers
44. hstore          | ACTIVE   |      | NULL    |         | data type for storing sets of (key, value) pairs
45. log_fdw         | ACTIVE   |      | NULL    |         | Foreign Data Wrapper for accessing logging data