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