pg如何安装插件

以自带的插件插件为例

之前装过了现在尝试删除

#;

…

以上说明被引用了可用用cascade的模式删除

postgres#dropextensionbloomcascade;

psql:NOTICE:dropcascadesto2otherobjects

DETAIL:dropcascadestoindexidxbloom_t2

dropcascadestoindexidx_t1

DROPEXTENSION

接下来安装比较简单

postgres#createextension

adminpackbtree_gistdict_xsynhstoreisnpageinspectpg_prewarmpg_visibilitytablefuncunaccent

amcheckcitextearthdistanceinsert_usernamelopg_buffercachepgrowlockspostgres_fdwtcn

autoinccubefile_fdwintaggltreepgcryptopg_stat_statementsrefinttsm_system_rows

btree_gindict_intfuzzystrmatchintarraymoddatetimepg_freespacemappgstattuplesegtsm_system_time

直接createextensionbloom即可

postgres#createextensionbloom;

CREATEEXTENSION

可以查询当前用了哪些插件

postgres-#\dx

Listofinstalledextensions

Name|Version|Schema|Description

bloom|1.0|public|bloomaccessmethod-signaturefilebasedindex

dblink|1.2|public|connecttootherPostgreSQLdatabasesfromwithinadatabase

pg_trgm|1.4|public|textsimilaritymeasurementandindexsearchingbasedontrigrams

plpgsql|1.0|pg_catalog|PL/pgSQLprocedurallanguage

(4rows)