SHOW PLUGINS

Function

View the plug-in list in the current database.

Precautions

N/A

Syntax

SHOW PLUGINS

Parameter Description

N/A

Examples

--View the plug-in list.
openGauss=# SHOW PLUGINS;
      Name       |  Status  | Type | Library | License |                      Comment                       
-----------------+----------+------+---------+---------+----------------------------------------------------
 roach_api_stub  | DISABLED |      | NULL    |         | roach api stub
 file_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for flat file access
 security_plugin | ACTIVE   |      | NULL    |         | provides security functionality
 hdfs_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for flat file access
 plpgsql         | ACTIVE   |      | NULL    |         | PL/pgSQL procedural language
 dolphin         | ACTIVE   |      | NULL    |         | sql engine
 dist_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for distfs access
 postgres_fdw    | DISABLED |      | NULL    |         | foreign-data wrapper for remote PostgreSQL servers
 hstore          | ACTIVE   |      | NULL    |         | data type for storing sets of (key, value) pairs
 log_fdw         | ACTIVE   |      | NULL    |         | Foreign Data Wrapper for accessing logging data

--Update the plug-in status.
openGauss=# drop extension hstore;
openGauss=# SHOW PLUGINS;
      Name       |  Status  | Type | Library | License |                      Comment                       
-----------------+----------+------+---------+---------+----------------------------------------------------
 roach_api_stub  | DISABLED |      | NULL    |         | roach api stub
 file_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for flat file access
 security_plugin | ACTIVE   |      | NULL    |         | provides security functionality
 hdfs_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for flat file access
 plpgsql         | ACTIVE   |      | NULL    |         | PL/pgSQL procedural language
 dolphin         | ACTIVE   |      | NULL    |         | sql engine
 dist_fdw        | ACTIVE   |      | NULL    |         | foreign-data wrapper for distfs access
 postgres_fdw    | DISABLED |      | NULL    |         | foreign-data wrapper for remote PostgreSQL servers
 hstore          | DISABLED |      | NULL    |         | data type for storing sets of (key, value) pairs
 log_fdw         | ACTIVE   |      | NULL    |         | Foreign Data Wrapper for accessing logging data

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