插件管理
最近更新时间: 2024-06-12 15:06:00
查看当前库加载了那些插件。
postgres=# \dx List of installedextensions Name | Version | Schema | Description --------------------+---------+------------+----------------------------------------------------------- pg_stat_statements | 1.1 | public | track execution statistics of all SQLstatements executed plpgsql | 1.0 | pg_catalog | PL/pgSQL procedurallanguage (2 rows)给当前库加载插件。
postgres=# create extension pg_stat_statements; CREATE EXTENSION删除当前库某个插件。
postgres=# drop extension pg_stat_statements; DROP EXTENSION