# 扩展

> 利用 PostgreSQL 扩展的协同超能力
---

Pigsty 允许您通过三样东西来利用 Postgres 扩展生态系统的协同超能力：目录、仓库和 pig。


**扩展目录**


        完整的 <span class="text-lg font-black text-emerald-500">437</span> 可用 PostgreSQL 扩展列表



**软件仓库**


        提供 PostgreSQL 扩展的 APT/YUM 仓库



**包管理器**


        PostgreSQL 和扩展缺失的包管理器



**快速开始**


        如何获取、安装、配置、管理这些扩展？







v3.7.0 扩展目录共收录 **437** 个 PostgreSQL 扩展，且 PostgreSQL 18 是默认版本。

下表是归档中保留的 PG13–17 兼容性快照，并未记录最终 PG18 分项统计；PG18 请以 v3.7.0 软件包别名和[发布说明](/zh/docs/release/latest)为准。

|  发行版   | 全部  | PGDG | PIGSTY | CONTRIB | 其他 | 缺失 | PG17 | PG16 | PG15 | PG14 | PG13 |
|:------:|:---:|:----:|:------:|:-------:|:--:|:--:|:----:|:----:|:----:|:----:|:----:|
|   EL   | 417 | 119  |  227   |   71    | 0  | 6  | 399  | 407  | 410  | 394  | 368  |
| Debian | 410 | 103  |  236   |   71    | 0  | 13 | 397  | 400  | 403  | 391  | 363  |


[![ecosystem](/img/pigsty/ecosystem.gif)](https://pgext.cloud/)

<a href="https://pgext.cloud/list/cate/#time" class="no-underline">时间</a>
<a href="https://pgext.cloud/list/cate/#gis" class="no-underline">地理</a>
<a href="https://pgext.cloud/list/cate/#rag" class="no-underline">向量</a>
<a href="https://pgext.cloud/list/cate/#fts" class="no-underline">搜索</a>
<a href="https://pgext.cloud/list/cate/#olap" class="no-underline">分析</a>
<a href="https://pgext.cloud/list/cate/#feat" class="no-underline">特性</a>
<a href="https://pgext.cloud/list/cate/#lang" class="no-underline">语言</a>
<a href="https://pgext.cloud/list/cate/#type" class="no-underline">类型</a>
<a href="https://pgext.cloud/list/cate/#util" class="no-underline">工具</a>
<a href="https://pgext.cloud/list/cate/#func" class="no-underline">函数</a>
<a href="https://pgext.cloud/list/cate/#admin" class="no-underline">管理</a>
<a href="https://pgext.cloud/list/cate/#stat" class="no-underline">统计</a>
<a href="https://pgext.cloud/list/cate/#sec" class="no-underline">安全</a>
<a href="https://pgext.cloud/list/cate/#fdw" class="no-underline">外部</a>
<a href="https://pgext.cloud/list/cate/#sim" class="no-underline">兼容</a>
<a href="https://pgext.cloud/list/cate/#etl" class="no-underline">数据</a>

<a href="https://pgext.cloud/list/license#mit"          class="no-underline">MIT</a>
<a href="https://pgext.cloud/list/license#isc"          class="no-underline">ISC</a>
<a href="https://pgext.cloud/list/license#postgresql"   class="no-underline">PostgreSQL</a>
<a href="https://pgext.cloud/list/license#bsd-0-clause" class="no-underline">BSD-0</a>
<a href="https://pgext.cloud/list/license#bsd-2-clause" class="no-underline">BSD-2</a>
<a href="https://pgext.cloud/list/license#bsd-3-clause" class="no-underline">BSD-3</a>
<a href="https://pgext.cloud/list/license#artistic"     class="no-underline">Artistic</a>
<a href="https://pgext.cloud/list/license#apache-20"    class="no-underline">Apache-2.0</a>
<a href="https://pgext.cloud/list/license#mpl-20"       class="no-underline">MPL-2.0</a>
<a href="https://pgext.cloud/list/license#gpl-20"       class="no-underline">GPL-2.0</a>
<a href="https://pgext.cloud/list/license#gpl-30"       class="no-underline">GPL-3.0</a>
<a href="https://pgext.cloud/list/license#lgpl-21"      class="no-underline">LGPL-2.1</a>
<a href="https://pgext.cloud/list/license#lgpl-30"      class="no-underline">LGPL-3.0</a>
<a href="https://pgext.cloud/list/license#agpl-30"      class="no-underline">AGPL-3.0</a>
<a href="https://pgext.cloud/list/license#timescale"    class="no-underline">Timescale</a>

- [C](https://pgext.cloud/list/lang#c)
- [C++](https://pgext.cloud/list/lang#c-1)
- [Rust](https://pgext.cloud/list/lang#rust)
- [Java](https://pgext.cloud/list/lang#java)
- [Python](https://pgext.cloud/list/lang#python)
- [SQL](https://pgext.cloud/list/lang#sql)
- [数据](https://pgext.cloud/list/lang#data)


-------

## 使用方法 {#usage}



**包**


        使用包别名下载和安装扩展




**下载**


        从 PGDG / Pigsty 仓库下载扩展




**安装**


        安装 Postgres 扩展包




**配置**


        配置扩展并设置预加载




**下载**


        从 PGDG / Pigsty 仓库下载扩展




**安装**


        安装 Postgres 扩展包




**配置**


        配置扩展并设置预加载




**创建**


        在数据库中创建 Postgres 扩展




**更新**


        升级 Postgres 扩展




**移除**


        卸载 Postgres 扩展






-------

## 索引 {#index}

| 类别 | 扩展 |
|:--------:|:-----------|
| <a href="https://pgext.cloud/list/cate/#time" class="no-underline">时间</a> | [`emaj`](https://pgext.cloud/e/emaj) [`periods`](https://pgext.cloud/e/periods) [`pg_background`](https://pgext.cloud/e/pg_background) [`pg_cron`](https://pgext.cloud/e/pg_cron) [`pg_later`](https://pgext.cloud/e/pg_later) [`pg_task`](https://pgext.cloud/e/pg_task) [`table_version`](https://pgext.cloud/e/table_version) [`temporal_tables`](https://pgext.cloud/e/temporal_tables) [`timescaledb`](https://pgext.cloud/e/timescaledb) [`timescaledb_toolkit`](https://pgext.cloud/e/timescaledb_toolkit) [`timeseries`](https://pgext.cloud/e/timeseries) |
| <a href="https://pgext.cloud/list/cate/#gis" class="no-underline">地理</a> | [`address_standardizer`](https://pgext.cloud/e/address_standardizer) [`address_standardizer_data_us`](https://pgext.cloud/e/address_standardizer_data_us) [`earthdistance`](https://pgext.cloud/e/earthdistance) [`geoip`](https://pgext.cloud/e/geoip) [`h3`](https://pgext.cloud/e/h3) [`h3_postgis`](https://pgext.cloud/e/h3_postgis) [`mobilitydb`](https://pgext.cloud/e/mobilitydb) [`ogr_fdw`](https://pgext.cloud/e/ogr_fdw) [`pg_geohash`](https://pgext.cloud/e/pg_geohash) [`pg_polyline`](https://pgext.cloud/e/pg_polyline) [`pgrouting`](https://pgext.cloud/e/pgrouting) [`pointcloud`](https://pgext.cloud/e/pointcloud) [`pointcloud_postgis`](https://pgext.cloud/e/pointcloud_postgis) [`postgis`](https://pgext.cloud/e/postgis) [`postgis_raster`](https://pgext.cloud/e/postgis_raster) [`postgis_sfcgal`](https://pgext.cloud/e/postgis_sfcgal) [`postgis_tiger_geocoder`](https://pgext.cloud/e/postgis_tiger_geocoder) [`postgis_topology`](https://pgext.cloud/e/postgis_topology) [`q3c`](https://pgext.cloud/e/q3c) [`tzf`](https://pgext.cloud/e/tzf) |
| <a href="https://pgext.cloud/list/cate/#rag" class="no-underline">向量</a> | [`pg4ml`](https://pgext.cloud/e/pg4ml) [`pg_similarity`](https://pgext.cloud/e/pg_similarity) [`pg_summarize`](https://pgext.cloud/e/pg_summarize) [`pg_tiktoken`](https://pgext.cloud/e/pg_tiktoken) [`pgml`](https://pgext.cloud/e/pgml) [`smlar`](https://pgext.cloud/e/smlar) [`vchord`](https://pgext.cloud/e/vchord) [`vector`](https://pgext.cloud/e/vector) [`vectorize`](https://pgext.cloud/e/vectorize) [`vectorscale`](https://pgext.cloud/e/vectorscale) |
| <a href="https://pgext.cloud/list/cate/#fts" class="no-underline">搜索</a> | [`fuzzystrmatch`](https://pgext.cloud/e/fuzzystrmatch) [`hunspell_cs_cz`](https://pgext.cloud/e/hunspell_cs_cz) [`hunspell_de_de`](https://pgext.cloud/e/hunspell_de_de) [`hunspell_en_us`](https://pgext.cloud/e/hunspell_en_us) [`hunspell_fr`](https://pgext.cloud/e/hunspell_fr) [`hunspell_ne_np`](https://pgext.cloud/e/hunspell_ne_np) [`hunspell_nl_nl`](https://pgext.cloud/e/hunspell_nl_nl) [`hunspell_nn_no`](https://pgext.cloud/e/hunspell_nn_no) [`hunspell_pt_pt`](https://pgext.cloud/e/hunspell_pt_pt) [`hunspell_ru_ru`](https://pgext.cloud/e/hunspell_ru_ru) [`hunspell_ru_ru_aot`](https://pgext.cloud/e/hunspell_ru_ru_aot) [`pg_bestmatch`](https://pgext.cloud/e/pg_bestmatch) [`pg_bigm`](https://pgext.cloud/e/pg_bigm) [`pg_search`](https://pgext.cloud/e/pg_search) [`pg_tokenizer`](https://pgext.cloud/e/pg_tokenizer) [`pg_trgm`](https://pgext.cloud/e/pg_trgm) [`pgroonga`](https://pgext.cloud/e/pgroonga) [`pgroonga_database`](https://pgext.cloud/e/pgroonga_database) [`vchord_bm25`](https://pgext.cloud/e/vchord_bm25) [`zhparser`](https://pgext.cloud/e/zhparser) |
| <a href="https://pgext.cloud/list/cate/#olap" class="no-underline">分析</a> | [`citus`](https://pgext.cloud/e/citus) [`citus_columnar`](https://pgext.cloud/e/citus_columnar) [`columnar`](https://pgext.cloud/e/columnar) [`duckdb_fdw`](https://pgext.cloud/e/duckdb_fdw) [`pg_analytics`](https://pgext.cloud/e/pg_analytics) [`pg_duckdb`](https://pgext.cloud/e/pg_duckdb) [`pg_fkpart`](https://pgext.cloud/e/pg_fkpart) [`pg_mooncake`](https://pgext.cloud/e/pg_mooncake) [`pg_parquet`](https://pgext.cloud/e/pg_parquet) [`pg_partman`](https://pgext.cloud/e/pg_partman) [`pg_strom`](https://pgext.cloud/e/pg_strom) [`plproxy`](https://pgext.cloud/e/plproxy) [`tablefunc`](https://pgext.cloud/e/tablefunc) |
| <a href="https://pgext.cloud/list/cate/#feat" class="no-underline">特性</a> | [`age`](https://pgext.cloud/e/age) [`bloom`](https://pgext.cloud/e/bloom) [`hll`](https://pgext.cloud/e/hll) [`hypopg`](https://pgext.cloud/e/hypopg) [`imgsmlr`](https://pgext.cloud/e/imgsmlr) [`index_advisor`](https://pgext.cloud/e/index_advisor) [`jsquery`](https://pgext.cloud/e/jsquery) [`omni`](https://pgext.cloud/e/omni) [`omni_auth`](https://pgext.cloud/e/omni_auth) [`omni_aws`](https://pgext.cloud/e/omni_aws) [`omni_cloudevents`](https://pgext.cloud/e/omni_cloudevents) [`omni_containers`](https://pgext.cloud/e/omni_containers) [`omni_credentials`](https://pgext.cloud/e/omni_credentials) [`omni_email`](https://pgext.cloud/e/omni_email) [`omni_http`](https://pgext.cloud/e/omni_http) [`omni_httpc`](https://pgext.cloud/e/omni_httpc) [`omni_httpd`](https://pgext.cloud/e/omni_httpd) [`omni_id`](https://pgext.cloud/e/omni_id) [`omni_json`](https://pgext.cloud/e/omni_json) [`omni_kube`](https://pgext.cloud/e/omni_kube) [`omni_ledger`](https://pgext.cloud/e/omni_ledger) [`omni_manifest`](https://pgext.cloud/e/omni_manifest) [`omni_mimetypes`](https://pgext.cloud/e/omni_mimetypes) [`omni_os`](https://pgext.cloud/e/omni_os) [`omni_polyfill`](https://pgext.cloud/e/omni_polyfill) [`omni_python`](https://pgext.cloud/e/omni_python) [`omni_regex`](https://pgext.cloud/e/omni_regex) [`omni_rest`](https://pgext.cloud/e/omni_rest) [`omni_schema`](https://pgext.cloud/e/omni_schema) [`omni_seq`](https://pgext.cloud/e/omni_seq) [`omni_service`](https://pgext.cloud/e/omni_service) [`omni_session`](https://pgext.cloud/e/omni_session) [`omni_sql`](https://pgext.cloud/e/omni_sql) [`omni_sqlite`](https://pgext.cloud/e/omni_sqlite) [`omni_test`](https://pgext.cloud/e/omni_test) [`omni_txn`](https://pgext.cloud/e/omni_txn) [`omni_types`](https://pgext.cloud/e/omni_types) [`omni_var`](https://pgext.cloud/e/omni_var) [`omni_vfs`](https://pgext.cloud/e/omni_vfs) [`omni_vfs_types_v1`](https://pgext.cloud/e/omni_vfs_types_v1) [`omni_web`](https://pgext.cloud/e/omni_web) [`omni_worker`](https://pgext.cloud/e/omni_worker) [`omni_xml`](https://pgext.cloud/e/omni_xml) [`omni_yaml`](https://pgext.cloud/e/omni_yaml) [`orioledb`](https://pgext.cloud/e/orioledb) [`pg_cardano`](https://pgext.cloud/e/pg_cardano) [`pg_graphql`](https://pgext.cloud/e/pg_graphql) [`pg_hint_plan`](https://pgext.cloud/e/pg_hint_plan) [`pg_incremental`](https://pgext.cloud/e/pg_incremental) [`pg_ivm`](https://pgext.cloud/e/pg_ivm) [`pg_jsonschema`](https://pgext.cloud/e/pg_jsonschema) [`pgmq`](https://pgext.cloud/e/pgmq) [`pgq`](https://pgext.cloud/e/pgq) [`plan_filter`](https://pgext.cloud/e/plan_filter) [`rdkit`](https://pgext.cloud/e/rdkit) [`rum`](https://pgext.cloud/e/rum) |
| <a href="https://pgext.cloud/list/cate/#lang" class="no-underline">语言</a> | [`bool_plperl`](https://pgext.cloud/e/bool_plperl) [`bool_plperlu`](https://pgext.cloud/e/bool_plperlu) [`dbt2`](https://pgext.cloud/e/dbt2) [`faker`](https://pgext.cloud/e/faker) [`hstore_pllua`](https://pgext.cloud/e/hstore_pllua) [`hstore_plluau`](https://pgext.cloud/e/hstore_plluau) [`hstore_plperl`](https://pgext.cloud/e/hstore_plperl) [`hstore_plperlu`](https://pgext.cloud/e/hstore_plperlu) [`hstore_plpython3u`](https://pgext.cloud/e/hstore_plpython3u) [`jsonb_plperl`](https://pgext.cloud/e/jsonb_plperl) [`jsonb_plperlu`](https://pgext.cloud/e/jsonb_plperlu) [`jsonb_plpython3u`](https://pgext.cloud/e/jsonb_plpython3u) [`ltree_plpython3u`](https://pgext.cloud/e/ltree_plpython3u) [`pg_tle`](https://pgext.cloud/e/pg_tle) [`pgtap`](https://pgext.cloud/e/pgtap) [`pldbgapi`](https://pgext.cloud/e/pldbgapi) [`pljava`](https://pgext.cloud/e/pljava) [`pllua`](https://pgext.cloud/e/pllua) [`plluau`](https://pgext.cloud/e/plluau) [`plperl`](https://pgext.cloud/e/plperl) [`plperlu`](https://pgext.cloud/e/plperlu) [`plpgsql`](https://pgext.cloud/e/plpgsql) [`plpgsql_check`](https://pgext.cloud/e/plpgsql_check) [`plprofiler`](https://pgext.cloud/e/plprofiler) [`plprql`](https://pgext.cloud/e/plprql) [`plpython3u`](https://pgext.cloud/e/plpython3u) [`plr`](https://pgext.cloud/e/plr) [`plsh`](https://pgext.cloud/e/plsh) [`pltcl`](https://pgext.cloud/e/pltcl) [`pltclu`](https://pgext.cloud/e/pltclu) [`plv8`](https://pgext.cloud/e/plv8) |
| <a href="https://pgext.cloud/list/cate/#type" class="no-underline">类型</a> | [`acl`](https://pgext.cloud/e/acl) [`asn1oid`](https://pgext.cloud/e/asn1oid) [`chkpass`](https://pgext.cloud/e/chkpass) [`citext`](https://pgext.cloud/e/citext) [`collection`](https://pgext.cloud/e/collection) [`country`](https://pgext.cloud/e/country) [`cube`](https://pgext.cloud/e/cube) [`currency`](https://pgext.cloud/e/currency) [`debversion`](https://pgext.cloud/e/debversion) [`emailaddr`](https://pgext.cloud/e/emailaddr) [`hashtypes`](https://pgext.cloud/e/hashtypes) [`hstore`](https://pgext.cloud/e/hstore) [`ip4r`](https://pgext.cloud/e/ip4r) [`isn`](https://pgext.cloud/e/isn) [`l10n_table_dependent_extension`](https://pgext.cloud/e/l10n_table_dependent_extension) [`ltree`](https://pgext.cloud/e/ltree) [`md5hash`](https://pgext.cloud/e/md5hash) [`numeral`](https://pgext.cloud/e/numeral) [`pg_duration`](https://pgext.cloud/e/pg_duration) [`pg_rational`](https://pgext.cloud/e/pg_rational) [`pg_rrule`](https://pgext.cloud/e/pg_rrule) [`pg_sphere`](https://pgext.cloud/e/pg_sphere) [`pg_xenophile`](https://pgext.cloud/e/pg_xenophile) [`pgfaceting`](https://pgext.cloud/e/pgfaceting) [`pglite_fusion`](https://pgext.cloud/e/pglite_fusion) [`pgmp`](https://pgext.cloud/e/pgmp) [`pgpdf`](https://pgext.cloud/e/pgpdf) [`prefix`](https://pgext.cloud/e/prefix) [`roaringbitmap`](https://pgext.cloud/e/roaringbitmap) [`seg`](https://pgext.cloud/e/seg) [`semver`](https://pgext.cloud/e/semver) [`timestamp9`](https://pgext.cloud/e/timestamp9) [`uint`](https://pgext.cloud/e/uint) [`uint128`](https://pgext.cloud/e/uint128) [`unit`](https://pgext.cloud/e/unit) [`uri`](https://pgext.cloud/e/uri) [`xml2`](https://pgext.cloud/e/xml2) |
| <a href="https://pgext.cloud/list/cate/#util" class="no-underline">工具</a> | [`bzip`](https://pgext.cloud/e/bzip) [`cryptint`](https://pgext.cloud/e/cryptint) [`data_historization`](https://pgext.cloud/e/data_historization) [`ddl_historization`](https://pgext.cloud/e/ddl_historization) [`envvar`](https://pgext.cloud/e/envvar) [`floatfile`](https://pgext.cloud/e/floatfile) [`gzip`](https://pgext.cloud/e/gzip) [`hashlib`](https://pgext.cloud/e/hashlib) [`http`](https://pgext.cloud/e/http) [`icu_ext`](https://pgext.cloud/e/icu_ext) [`pg_curl`](https://pgext.cloud/e/pg_curl) [`pg_extra_time`](https://pgext.cloud/e/pg_extra_time) [`pg_html5_email_address`](https://pgext.cloud/e/pg_html5_email_address) [`pg_net`](https://pgext.cloud/e/pg_net) [`pg_protobuf`](https://pgext.cloud/e/pg_protobuf) [`pg_readme`](https://pgext.cloud/e/pg_readme) [`pg_readme_test_extension`](https://pgext.cloud/e/pg_readme_test_extension) [`pg_render`](https://pgext.cloud/e/pg_render) [`pg_smtp_client`](https://pgext.cloud/e/pg_smtp_client) [`pgjq`](https://pgext.cloud/e/pgjq) [`pgjwt`](https://pgext.cloud/e/pgjwt) [`pgpcre`](https://pgext.cloud/e/pgpcre) [`pgqr`](https://pgext.cloud/e/pgqr) [`pgsql_tweaks`](https://pgext.cloud/e/pgsql_tweaks) [`pguecc`](https://pgext.cloud/e/pguecc) [`schedoc`](https://pgext.cloud/e/schedoc) [`shacrypt`](https://pgext.cloud/e/shacrypt) [`sparql`](https://pgext.cloud/e/sparql) [`url_encode`](https://pgext.cloud/e/url_encode) [`xxhash`](https://pgext.cloud/e/xxhash) [`zstd`](https://pgext.cloud/e/zstd) |
| <a href="https://pgext.cloud/list/cate/#func" class="no-underline">函数</a> | [`aggs_for_arrays`](https://pgext.cloud/e/aggs_for_arrays) [`aggs_for_vecs`](https://pgext.cloud/e/aggs_for_vecs) [`arraymath`](https://pgext.cloud/e/arraymath) [`autoinc`](https://pgext.cloud/e/autoinc) [`base36`](https://pgext.cloud/e/base36) [`base62`](https://pgext.cloud/e/base62) [`btree_gin`](https://pgext.cloud/e/btree_gin) [`btree_gist`](https://pgext.cloud/e/btree_gist) [`convert`](https://pgext.cloud/e/convert) [`count_distinct`](https://pgext.cloud/e/count_distinct) [`ddsketch`](https://pgext.cloud/e/ddsketch) [`dict_int`](https://pgext.cloud/e/dict_int) [`dict_xsyn`](https://pgext.cloud/e/dict_xsyn) [`extra_window_functions`](https://pgext.cloud/e/extra_window_functions) [`financial`](https://pgext.cloud/e/financial) [`first_last_agg`](https://pgext.cloud/e/first_last_agg) [`floatvec`](https://pgext.cloud/e/floatvec) [`insert_username`](https://pgext.cloud/e/insert_username) [`intagg`](https://pgext.cloud/e/intagg) [`intarray`](https://pgext.cloud/e/intarray) [`lower_quantile`](https://pgext.cloud/e/lower_quantile) [`moddatetime`](https://pgext.cloud/e/moddatetime) [`omnisketch`](https://pgext.cloud/e/omnisketch) [`permuteseq`](https://pgext.cloud/e/permuteseq) [`pg_base58`](https://pgext.cloud/e/pg_base58) [`pg_hashids`](https://pgext.cloud/e/pg_hashids) [`pg_idkit`](https://pgext.cloud/e/pg_idkit) [`pg_math`](https://pgext.cloud/e/pg_math) [`pg_uuidv7`](https://pgext.cloud/e/pg_uuidv7) [`pgx_ulid`](https://pgext.cloud/e/pgx_ulid) [`quantile`](https://pgext.cloud/e/quantile) [`random`](https://pgext.cloud/e/random) [`refint`](https://pgext.cloud/e/refint) [`sequential_uuids`](https://pgext.cloud/e/sequential_uuids) [`tcn`](https://pgext.cloud/e/tcn) [`tdigest`](https://pgext.cloud/e/tdigest) [`topn`](https://pgext.cloud/e/topn) [`tsm_system_rows`](https://pgext.cloud/e/tsm_system_rows) [`tsm_system_time`](https://pgext.cloud/e/tsm_system_time) [`unaccent`](https://pgext.cloud/e/unaccent) [`uuid-ossp`](https://pgext.cloud/e/uuid-ossp) [`vasco`](https://pgext.cloud/e/vasco) [`xicor`](https://pgext.cloud/e/xicor) |
| <a href="https://pgext.cloud/list/cate/#admin" class="no-underline">管理</a> | [`adminpack`](https://pgext.cloud/e/adminpack) [`amcheck`](https://pgext.cloud/e/amcheck) [`basebackup_to_shell`](https://pgext.cloud/e/basebackup_to_shell) [`basic_archive`](https://pgext.cloud/e/basic_archive) [`ddlx`](https://pgext.cloud/e/ddlx) [`fio`](https://pgext.cloud/e/fio) [`lo`](https://pgext.cloud/e/lo) [`old_snapshot`](https://pgext.cloud/e/old_snapshot) [`pg_catcheck`](https://pgext.cloud/e/pg_catcheck) [`pg_cheat_funcs`](https://pgext.cloud/e/pg_cheat_funcs) [`pg_checksums`](https://pgext.cloud/e/pg_checksums) [`pg_cooldown`](https://pgext.cloud/e/pg_cooldown) [`pg_crash`](https://pgext.cloud/e/pg_crash) [`pg_dirtyread`](https://pgext.cloud/e/pg_dirtyread) [`pg_drop_events`](https://pgext.cloud/e/pg_drop_events) [`pg_orphaned`](https://pgext.cloud/e/pg_orphaned) [`pg_permissions`](https://pgext.cloud/e/pg_permissions) [`pg_prewarm`](https://pgext.cloud/e/pg_prewarm) [`pg_readonly`](https://pgext.cloud/e/pg_readonly) [`pg_repack`](https://pgext.cloud/e/pg_repack) [`pg_savior`](https://pgext.cloud/e/pg_savior) [`pg_squeeze`](https://pgext.cloud/e/pg_squeeze) [`pg_surgery`](https://pgext.cloud/e/pg_surgery) [`pg_upless`](https://pgext.cloud/e/pg_upless) [`pgagent`](https://pgext.cloud/e/pgagent) [`pgautofailover`](https://pgext.cloud/e/pgautofailover) [`pgcozy`](https://pgext.cloud/e/pgcozy) [`pgdd`](https://pgext.cloud/e/pgdd) [`pgfincore`](https://pgext.cloud/e/pgfincore) [`pgpool_adm`](https://pgext.cloud/e/pgpool_adm) [`pgpool_recovery`](https://pgext.cloud/e/pgpool_recovery) [`pgpool_regclass`](https://pgext.cloud/e/pgpool_regclass) [`pre_prepare`](https://pgext.cloud/e/pre_prepare) [`prioritize`](https://pgext.cloud/e/prioritize) [`safeupdate`](https://pgext.cloud/e/safeupdate) [`table_log`](https://pgext.cloud/e/table_log) |
| <a href="https://pgext.cloud/list/cate/#stat" class="no-underline">统计</a> | [`auto_explain`](https://pgext.cloud/e/auto_explain) [`bgw_replstatus`](https://pgext.cloud/e/bgw_replstatus) [`explain_ui`](https://pgext.cloud/e/explain_ui) [`meta`](https://pgext.cloud/e/meta) [`pageinspect`](https://pgext.cloud/e/pageinspect) [`pagevis`](https://pgext.cloud/e/pagevis) [`pg_buffercache`](https://pgext.cloud/e/pg_buffercache) [`pg_freespacemap`](https://pgext.cloud/e/pg_freespacemap) [`pg_logicalinspect`](https://pgext.cloud/e/pg_logicalinspect) [`pg_overexplain`](https://pgext.cloud/e/pg_overexplain) [`pg_proctab`](https://pgext.cloud/e/pg_proctab) [`pg_profile`](https://pgext.cloud/e/pg_profile) [`pg_qualstats`](https://pgext.cloud/e/pg_qualstats) [`pg_relusage`](https://pgext.cloud/e/pg_relusage) [`pg_show_plans`](https://pgext.cloud/e/pg_show_plans) [`pg_sqlog`](https://pgext.cloud/e/pg_sqlog) [`pg_stat_kcache`](https://pgext.cloud/e/pg_stat_kcache) [`pg_stat_monitor`](https://pgext.cloud/e/pg_stat_monitor) [`pg_stat_statements`](https://pgext.cloud/e/pg_stat_statements) [`pg_store_plans`](https://pgext.cloud/e/pg_store_plans) [`pg_tracing`](https://pgext.cloud/e/pg_tracing) [`pg_track_settings`](https://pgext.cloud/e/pg_track_settings) [`pg_visibility`](https://pgext.cloud/e/pg_visibility) [`pg_wait_sampling`](https://pgext.cloud/e/pg_wait_sampling) [`pg_walinspect`](https://pgext.cloud/e/pg_walinspect) [`pgmeminfo`](https://pgext.cloud/e/pgmeminfo) [`pgnodemx`](https://pgext.cloud/e/pgnodemx) [`pgrowlocks`](https://pgext.cloud/e/pgrowlocks) [`pgsentinel`](https://pgext.cloud/e/pgsentinel) [`pgstattuple`](https://pgext.cloud/e/pgstattuple) [`powa`](https://pgext.cloud/e/powa) [`sslinfo`](https://pgext.cloud/e/sslinfo) [`system_stats`](https://pgext.cloud/e/system_stats) [`toastinfo`](https://pgext.cloud/e/toastinfo) |
| <a href="https://pgext.cloud/list/cate/#sec" class="no-underline">安全</a> | [`anon`](https://pgext.cloud/e/anon) [`auth_delay`](https://pgext.cloud/e/auth_delay) [`credcheck`](https://pgext.cloud/e/credcheck) [`logerrors`](https://pgext.cloud/e/logerrors) [`login_hook`](https://pgext.cloud/e/login_hook) [`noset`](https://pgext.cloud/e/noset) [`passwordcheck`](https://pgext.cloud/e/passwordcheck) [`passwordcheck_cracklib`](https://pgext.cloud/e/passwordcheck_cracklib) [`pg_auditor`](https://pgext.cloud/e/pg_auditor) [`pg_auth_mon`](https://pgext.cloud/e/pg_auth_mon) [`pg_jobmon`](https://pgext.cloud/e/pg_jobmon) [`pg_session_jwt`](https://pgext.cloud/e/pg_session_jwt) [`pg_snakeoil`](https://pgext.cloud/e/pg_snakeoil) [`pg_tde`](https://pgext.cloud/e/pg_tde) [`pgaudit`](https://pgext.cloud/e/pgaudit) [`pgauditlogtofile`](https://pgext.cloud/e/pgauditlogtofile) [`pgcrypto`](https://pgext.cloud/e/pgcrypto) [`pgcryptokey`](https://pgext.cloud/e/pgcryptokey) [`pgextwlist`](https://pgext.cloud/e/pgextwlist) [`pgsmcrypto`](https://pgext.cloud/e/pgsmcrypto) [`pgsodium`](https://pgext.cloud/e/pgsodium) [`sepgsql`](https://pgext.cloud/e/sepgsql) [`set_user`](https://pgext.cloud/e/set_user) [`sslutils`](https://pgext.cloud/e/sslutils) [`supabase_vault`](https://pgext.cloud/e/supabase_vault) [`supautils`](https://pgext.cloud/e/supautils) |
| <a href="https://pgext.cloud/list/cate/#fdw" class="no-underline">外部</a> | [`aws_s3`](https://pgext.cloud/e/aws_s3) [`db2_fdw`](https://pgext.cloud/e/db2_fdw) [`dblink`](https://pgext.cloud/e/dblink) [`file_fdw`](https://pgext.cloud/e/file_fdw) [`firebird_fdw`](https://pgext.cloud/e/firebird_fdw) [`hdfs_fdw`](https://pgext.cloud/e/hdfs_fdw) [`jdbc_fdw`](https://pgext.cloud/e/jdbc_fdw) [`kafka_fdw`](https://pgext.cloud/e/kafka_fdw) [`log_fdw`](https://pgext.cloud/e/log_fdw) [`mongo_fdw`](https://pgext.cloud/e/mongo_fdw) [`multicorn`](https://pgext.cloud/e/multicorn) [`mysql_fdw`](https://pgext.cloud/e/mysql_fdw) [`odbc_fdw`](https://pgext.cloud/e/odbc_fdw) [`oracle_fdw`](https://pgext.cloud/e/oracle_fdw) [`pgbouncer_fdw`](https://pgext.cloud/e/pgbouncer_fdw) [`pgspider_ext`](https://pgext.cloud/e/pgspider_ext) [`postgres_fdw`](https://pgext.cloud/e/postgres_fdw) [`redis`](https://pgext.cloud/e/redis) [`redis_fdw`](https://pgext.cloud/e/redis_fdw) [`sqlite_fdw`](https://pgext.cloud/e/sqlite_fdw) [`tds_fdw`](https://pgext.cloud/e/tds_fdw) [`wrappers`](https://pgext.cloud/e/wrappers) |
| <a href="https://pgext.cloud/list/cate/#sim" class="no-underline">兼容</a> | [`babelfishpg_common`](https://pgext.cloud/e/babelfishpg_common) [`babelfishpg_money`](https://pgext.cloud/e/babelfishpg_money) [`babelfishpg_tds`](https://pgext.cloud/e/babelfishpg_tds) [`babelfishpg_tsql`](https://pgext.cloud/e/babelfishpg_tsql) [`documentdb`](https://pgext.cloud/e/documentdb) [`documentdb_core`](https://pgext.cloud/e/documentdb_core) [`documentdb_distributed`](https://pgext.cloud/e/documentdb_distributed) [`orafce`](https://pgext.cloud/e/orafce) [`pg_dbms_job`](https://pgext.cloud/e/pg_dbms_job) [`pg_dbms_lock`](https://pgext.cloud/e/pg_dbms_lock) [`pg_dbms_metadata`](https://pgext.cloud/e/pg_dbms_metadata) [`pg_statement_rollback`](https://pgext.cloud/e/pg_statement_rollback) [`pgmemcache`](https://pgext.cloud/e/pgmemcache) [`pgtt`](https://pgext.cloud/e/pgtt) [`session_variable`](https://pgext.cloud/e/session_variable) [`spat`](https://pgext.cloud/e/spat) |
| <a href="https://pgext.cloud/list/cate/#etl" class="no-underline">数据</a> | [`db_migrator`](https://pgext.cloud/e/db_migrator) [`decoder_raw`](https://pgext.cloud/e/decoder_raw) [`decoderbufs`](https://pgext.cloud/e/decoderbufs) [`mimeo`](https://pgext.cloud/e/mimeo) [`pg_bulkload`](https://pgext.cloud/e/pg_bulkload) [`pg_fact_loader`](https://pgext.cloud/e/pg_fact_loader) [`pg_failover_slots`](https://pgext.cloud/e/pg_failover_slots) [`pgactive`](https://pgext.cloud/e/pgactive) [`pgl_ddl_deploy`](https://pgext.cloud/e/pgl_ddl_deploy) [`pglogical`](https://pgext.cloud/e/pglogical) [`pglogical_origin`](https://pgext.cloud/e/pglogical_origin) [`pglogical_ticker`](https://pgext.cloud/e/pglogical_ticker) [`pgoutput`](https://pgext.cloud/e/pgoutput) [`repmgr`](https://pgext.cloud/e/repmgr) [`test_decoding`](https://pgext.cloud/e/test_decoding) [`wal2json`](https://pgext.cloud/e/wal2json) [`wal2mongo`](https://pgext.cloud/e/wal2mongo) |

---

本节页面：

- [快速开始](/zh/docs/pgsql/extension/start/): 安装、加载、创建、更新 PostgreSQL 扩展
- [软件包](/zh/docs/pgsql/extension/pkg/): 扩展包和别名
- [下载](/zh/docs/pgsql/extension/download/): 下载 PostgreSQL 扩展
- [安装](/zh/docs/pgsql/extension/install/): 安装 PostgreSQL 扩展
- [配置](/zh/docs/pgsql/extension/config/): 预加载扩展并配置扩展参数
- [创建](/zh/docs/pgsql/extension/create/): 创建和启用 PostgreSQL 扩展
- [更新](/zh/docs/pgsql/extension/update/): 如何将 PostgreSQL 扩展更新到新版本
- [移除](/zh/docs/pgsql/extension/remove/): 如何移除 PostgreSQL 扩展