addressing_dictionary

面向地址缩写归一化的全文检索词典与配置

概览

扩展包名	版本	分类	许可证	语言
`addressing_dictionary`	`1.1`	FTS	MIT	SQL

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
2270	`addressing_dictionary`	否	否	否	是	否	是	-

相关扩展	`address_standardizer` `address_standardizer_data_us` `postal` `unaccent` `hunspell_en_us`

SQL and dictionary data only; no shared library. PostgreSQL 14-18 verified in PGSTY builds; upstream declares no current major-version matrix.

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	PIGSTY	`1.1`	1817161514	`addressing_dictionary`	-
RPM	PIGSTY	`1.1`	1817161514	`addressing_dictionary_$v`	-
DEB	PIGSTY	`1.1`	1817161514	`postgresql-$v-addressing-dictionary`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 1.1 el8.x86_64.pg18 : addressing_dictionary_18 addressing_dictionary_18-1.1-1PGSTY.el8.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el8.x86_64.pg17 : addressing_dictionary_17 addressing_dictionary_17-1.1-1PGSTY.el8.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el8.x86_64.pg16 : addressing_dictionary_16 addressing_dictionary_16-1.1-1PGSTY.el8.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el8.x86_64.pg15 : addressing_dictionary_15 addressing_dictionary_15-1.1-1PGSTY.el8.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el8.x86_64.pg14 : addressing_dictionary_14 addressing_dictionary_14-1.1-1PGSTY.el8.noarch.rpm PIGSTY · 1.1 · 11.5KiB
el8.aarch64	PIGSTY 1.1 el8.aarch64.pg18 : addressing_dictionary_18 addressing_dictionary_18-1.1-1PGSTY.el8.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el8.aarch64.pg17 : addressing_dictionary_17 addressing_dictionary_17-1.1-1PGSTY.el8.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el8.aarch64.pg16 : addressing_dictionary_16 addressing_dictionary_16-1.1-1PGSTY.el8.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el8.aarch64.pg15 : addressing_dictionary_15 addressing_dictionary_15-1.1-1PGSTY.el8.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el8.aarch64.pg14 : addressing_dictionary_14 addressing_dictionary_14-1.1-1PGSTY.el8.noarch.rpm PIGSTY · 1.1 · 11.5KiB
el9.x86_64	PIGSTY 1.1 el9.x86_64.pg18 : addressing_dictionary_18 addressing_dictionary_18-1.1-1PGSTY.el9.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el9.x86_64.pg17 : addressing_dictionary_17 addressing_dictionary_17-1.1-1PGSTY.el9.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el9.x86_64.pg16 : addressing_dictionary_16 addressing_dictionary_16-1.1-1PGSTY.el9.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el9.x86_64.pg15 : addressing_dictionary_15 addressing_dictionary_15-1.1-1PGSTY.el9.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el9.x86_64.pg14 : addressing_dictionary_14 addressing_dictionary_14-1.1-1PGSTY.el9.noarch.rpm PIGSTY · 1.1 · 11.5KiB
el9.aarch64	PIGSTY 1.1 el9.aarch64.pg18 : addressing_dictionary_18 addressing_dictionary_18-1.1-1PGSTY.el9.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el9.aarch64.pg17 : addressing_dictionary_17 addressing_dictionary_17-1.1-1PGSTY.el9.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el9.aarch64.pg16 : addressing_dictionary_16 addressing_dictionary_16-1.1-1PGSTY.el9.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el9.aarch64.pg15 : addressing_dictionary_15 addressing_dictionary_15-1.1-1PGSTY.el9.noarch.rpm PIGSTY · 1.1 · 11.5KiB	PIGSTY 1.1 el9.aarch64.pg14 : addressing_dictionary_14 addressing_dictionary_14-1.1-1PGSTY.el9.noarch.rpm PIGSTY · 1.1 · 11.5KiB
el10.x86_64	PIGSTY 1.1 el10.x86_64.pg18 : addressing_dictionary_18 addressing_dictionary_18-1.1-1PGSTY.el10.noarch.rpm PIGSTY · 1.1 · 11.7KiB	PIGSTY 1.1 el10.x86_64.pg17 : addressing_dictionary_17 addressing_dictionary_17-1.1-1PGSTY.el10.noarch.rpm PIGSTY · 1.1 · 11.7KiB	PIGSTY 1.1 el10.x86_64.pg16 : addressing_dictionary_16 addressing_dictionary_16-1.1-1PGSTY.el10.noarch.rpm PIGSTY · 1.1 · 11.7KiB	PIGSTY 1.1 el10.x86_64.pg15 : addressing_dictionary_15 addressing_dictionary_15-1.1-1PGSTY.el10.noarch.rpm PIGSTY · 1.1 · 11.7KiB	PIGSTY 1.1 el10.x86_64.pg14 : addressing_dictionary_14 addressing_dictionary_14-1.1-1PGSTY.el10.noarch.rpm PIGSTY · 1.1 · 11.7KiB
el10.aarch64	PIGSTY 1.1 el10.aarch64.pg18 : addressing_dictionary_18 addressing_dictionary_18-1.1-1PGSTY.el10.noarch.rpm PIGSTY · 1.1 · 11.7KiB	PIGSTY 1.1 el10.aarch64.pg17 : addressing_dictionary_17 addressing_dictionary_17-1.1-1PGSTY.el10.noarch.rpm PIGSTY · 1.1 · 11.7KiB	PIGSTY 1.1 el10.aarch64.pg16 : addressing_dictionary_16 addressing_dictionary_16-1.1-1PGSTY.el10.noarch.rpm PIGSTY · 1.1 · 11.7KiB	PIGSTY 1.1 el10.aarch64.pg15 : addressing_dictionary_15 addressing_dictionary_15-1.1-1PGSTY.el10.noarch.rpm PIGSTY · 1.1 · 11.7KiB	PIGSTY 1.1 el10.aarch64.pg14 : addressing_dictionary_14 addressing_dictionary_14-1.1-1PGSTY.el10.noarch.rpm PIGSTY · 1.1 · 11.7KiB
d12.x86_64	PIGSTY 1.1 d12.x86_64.pg18 : postgresql-18-addressing-dictionary postgresql-18-addressing-dictionary_1.1-1PGSTY~bookworm_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d12.x86_64.pg17 : postgresql-17-addressing-dictionary postgresql-17-addressing-dictionary_1.1-1PGSTY~bookworm_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d12.x86_64.pg16 : postgresql-16-addressing-dictionary postgresql-16-addressing-dictionary_1.1-1PGSTY~bookworm_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d12.x86_64.pg15 : postgresql-15-addressing-dictionary postgresql-15-addressing-dictionary_1.1-1PGSTY~bookworm_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d12.x86_64.pg14 : postgresql-14-addressing-dictionary postgresql-14-addressing-dictionary_1.1-1PGSTY~bookworm_all.deb PIGSTY · 1.1 · 4.5KiB
d12.aarch64	PIGSTY 1.1 d12.aarch64.pg18 : postgresql-18-addressing-dictionary postgresql-18-addressing-dictionary_1.1-1PGSTY~bookworm_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d12.aarch64.pg17 : postgresql-17-addressing-dictionary postgresql-17-addressing-dictionary_1.1-1PGSTY~bookworm_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d12.aarch64.pg16 : postgresql-16-addressing-dictionary postgresql-16-addressing-dictionary_1.1-1PGSTY~bookworm_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d12.aarch64.pg15 : postgresql-15-addressing-dictionary postgresql-15-addressing-dictionary_1.1-1PGSTY~bookworm_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d12.aarch64.pg14 : postgresql-14-addressing-dictionary postgresql-14-addressing-dictionary_1.1-1PGSTY~bookworm_all.deb PIGSTY · 1.1 · 4.5KiB
d13.x86_64	PIGSTY 1.1 d13.x86_64.pg18 : postgresql-18-addressing-dictionary postgresql-18-addressing-dictionary_1.1-1PGSTY~trixie_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d13.x86_64.pg17 : postgresql-17-addressing-dictionary postgresql-17-addressing-dictionary_1.1-1PGSTY~trixie_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d13.x86_64.pg16 : postgresql-16-addressing-dictionary postgresql-16-addressing-dictionary_1.1-1PGSTY~trixie_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d13.x86_64.pg15 : postgresql-15-addressing-dictionary postgresql-15-addressing-dictionary_1.1-1PGSTY~trixie_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d13.x86_64.pg14 : postgresql-14-addressing-dictionary postgresql-14-addressing-dictionary_1.1-1PGSTY~trixie_all.deb PIGSTY · 1.1 · 4.5KiB
d13.aarch64	PIGSTY 1.1 d13.aarch64.pg18 : postgresql-18-addressing-dictionary postgresql-18-addressing-dictionary_1.1-1PGSTY~trixie_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d13.aarch64.pg17 : postgresql-17-addressing-dictionary postgresql-17-addressing-dictionary_1.1-1PGSTY~trixie_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d13.aarch64.pg16 : postgresql-16-addressing-dictionary postgresql-16-addressing-dictionary_1.1-1PGSTY~trixie_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d13.aarch64.pg15 : postgresql-15-addressing-dictionary postgresql-15-addressing-dictionary_1.1-1PGSTY~trixie_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 d13.aarch64.pg14 : postgresql-14-addressing-dictionary postgresql-14-addressing-dictionary_1.1-1PGSTY~trixie_all.deb PIGSTY · 1.1 · 4.5KiB
u22.x86_64	PIGSTY 1.1 u22.x86_64.pg18 : postgresql-18-addressing-dictionary postgresql-18-addressing-dictionary_1.1-1PGSTY~jammy_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u22.x86_64.pg17 : postgresql-17-addressing-dictionary postgresql-17-addressing-dictionary_1.1-1PGSTY~jammy_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u22.x86_64.pg16 : postgresql-16-addressing-dictionary postgresql-16-addressing-dictionary_1.1-1PGSTY~jammy_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u22.x86_64.pg15 : postgresql-15-addressing-dictionary postgresql-15-addressing-dictionary_1.1-1PGSTY~jammy_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u22.x86_64.pg14 : postgresql-14-addressing-dictionary postgresql-14-addressing-dictionary_1.1-1PGSTY~jammy_all.deb PIGSTY · 1.1 · 4.5KiB
u22.aarch64	PIGSTY 1.1 u22.aarch64.pg18 : postgresql-18-addressing-dictionary postgresql-18-addressing-dictionary_1.1-1PGSTY~jammy_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u22.aarch64.pg17 : postgresql-17-addressing-dictionary postgresql-17-addressing-dictionary_1.1-1PGSTY~jammy_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u22.aarch64.pg16 : postgresql-16-addressing-dictionary postgresql-16-addressing-dictionary_1.1-1PGSTY~jammy_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u22.aarch64.pg15 : postgresql-15-addressing-dictionary postgresql-15-addressing-dictionary_1.1-1PGSTY~jammy_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u22.aarch64.pg14 : postgresql-14-addressing-dictionary postgresql-14-addressing-dictionary_1.1-1PGSTY~jammy_all.deb PIGSTY · 1.1 · 4.5KiB
u24.x86_64	PIGSTY 1.1 u24.x86_64.pg18 : postgresql-18-addressing-dictionary postgresql-18-addressing-dictionary_1.1-1PGSTY~noble_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u24.x86_64.pg17 : postgresql-17-addressing-dictionary postgresql-17-addressing-dictionary_1.1-1PGSTY~noble_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u24.x86_64.pg16 : postgresql-16-addressing-dictionary postgresql-16-addressing-dictionary_1.1-1PGSTY~noble_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u24.x86_64.pg15 : postgresql-15-addressing-dictionary postgresql-15-addressing-dictionary_1.1-1PGSTY~noble_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u24.x86_64.pg14 : postgresql-14-addressing-dictionary postgresql-14-addressing-dictionary_1.1-1PGSTY~noble_all.deb PIGSTY · 1.1 · 4.5KiB
u24.aarch64	PIGSTY 1.1 u24.aarch64.pg18 : postgresql-18-addressing-dictionary postgresql-18-addressing-dictionary_1.1-1PGSTY~noble_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u24.aarch64.pg17 : postgresql-17-addressing-dictionary postgresql-17-addressing-dictionary_1.1-1PGSTY~noble_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u24.aarch64.pg16 : postgresql-16-addressing-dictionary postgresql-16-addressing-dictionary_1.1-1PGSTY~noble_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u24.aarch64.pg15 : postgresql-15-addressing-dictionary postgresql-15-addressing-dictionary_1.1-1PGSTY~noble_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u24.aarch64.pg14 : postgresql-14-addressing-dictionary postgresql-14-addressing-dictionary_1.1-1PGSTY~noble_all.deb PIGSTY · 1.1 · 4.5KiB
u26.x86_64	PIGSTY 1.1 u26.x86_64.pg18 : postgresql-18-addressing-dictionary postgresql-18-addressing-dictionary_1.1-1PGSTY~resolute_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u26.x86_64.pg17 : postgresql-17-addressing-dictionary postgresql-17-addressing-dictionary_1.1-1PGSTY~resolute_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u26.x86_64.pg16 : postgresql-16-addressing-dictionary postgresql-16-addressing-dictionary_1.1-1PGSTY~resolute_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u26.x86_64.pg15 : postgresql-15-addressing-dictionary postgresql-15-addressing-dictionary_1.1-1PGSTY~resolute_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u26.x86_64.pg14 : postgresql-14-addressing-dictionary postgresql-14-addressing-dictionary_1.1-1PGSTY~resolute_all.deb PIGSTY · 1.1 · 4.5KiB
u26.aarch64	PIGSTY 1.1 u26.aarch64.pg18 : postgresql-18-addressing-dictionary postgresql-18-addressing-dictionary_1.1-1PGSTY~resolute_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u26.aarch64.pg17 : postgresql-17-addressing-dictionary postgresql-17-addressing-dictionary_1.1-1PGSTY~resolute_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u26.aarch64.pg16 : postgresql-16-addressing-dictionary postgresql-16-addressing-dictionary_1.1-1PGSTY~resolute_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u26.aarch64.pg15 : postgresql-15-addressing-dictionary postgresql-15-addressing-dictionary_1.1-1PGSTY~resolute_all.deb PIGSTY · 1.1 · 3.5KiB	PIGSTY 1.1 u26.aarch64.pg14 : postgresql-14-addressing-dictionary postgresql-14-addressing-dictionary_1.1-1PGSTY~resolute_all.deb PIGSTY · 1.1 · 4.5KiB

构建

您可以使用 pig build 命令构建 addressing_dictionary 扩展的 RPM / DEB 包：

pig build pkg addressing_dictionary         # 构建 RPM / DEB 包

安装

您可以直接安装 addressing_dictionary 扩展包的预置二进制包，首先确保 PGDG 和 PIGSTY 仓库已经添加并启用：

pig repo add pgsql -u          # 添加仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展：

安装

pig install addressing_dictionary;          # 当前活跃 PG 版本安装

pig

pig ext install -y addressing_dictionary -v 18  # PG 18
pig ext install -y addressing_dictionary -v 17  # PG 17
pig ext install -y addressing_dictionary -v 16  # PG 16
pig ext install -y addressing_dictionary -v 15  # PG 15
pig ext install -y addressing_dictionary -v 14  # PG 14

dnf

dnf install -y addressing_dictionary_18       # PG 18
dnf install -y addressing_dictionary_17       # PG 17
dnf install -y addressing_dictionary_16       # PG 16
dnf install -y addressing_dictionary_15       # PG 15
dnf install -y addressing_dictionary_14       # PG 14

apt

apt install -y postgresql-18-addressing-dictionary   # PG 18
apt install -y postgresql-17-addressing-dictionary   # PG 17
apt install -y postgresql-16-addressing-dictionary   # PG 16
apt install -y postgresql-15-addressing-dictionary   # PG 15
apt install -y postgresql-14-addressing-dictionary   # PG 14

创建扩展：

CREATE EXTENSION addressing_dictionary;

用法

来源：

addressing_dictionary 安装面向地址的全文搜索配置与词典。它适合在本地地址近似检索中，把街道类型、方向和序数的不同写法归一为可比较的词位；它不是地理编码器，也不能替代地址解析与校验。

核心流程

在数据库中安装一次扩展，用所提供的配置归一化地址文本，并让索引表达式与查询表达式保持一致。

CREATE EXTENSION addressing_dictionary;

SELECT to_tsvector('addressing_en', '1234 n main st');

CREATE INDEX address_search_idx
ON address_book
USING gin (to_tsvector('addressing_en', full_address));

SELECT *
FROM address_book
WHERE to_tsvector('addressing_en', full_address)
      @@ plainto_tsquery('addressing_en', '1234 north main street');

1.1 版会保留方向缩写，同时产生展开形式，因此单字母的北向标记可以输出两种形式。这种设计刻意保留歧义，而不会假定每次出现都只有一种含义。

已安装对象

英文配置把地址标记的同义词词典、停用词词典和叙词表组合起来。
法文配置安装对应的法文文本搜索对象。
两套配置都复制自 PostgreSQL 的简单配置，因此通过扩展的数据文件归一化，而不是使用通用语言词干提取器。

运维边界

该扩展可重定位，不需要预加载或重启。所有可能执行查询或恢复扩展的服务器都必须安装其词典、同义词、停用词和叙词表文件。

全文匹配属于启发式方法。缩写可能有歧义，全国范围的数据也可能产生大量误匹配或重复候选。应把它用于改进候选检索，尤其是范围有限的城市或地区；对正确性有要求时，仍需另外使用结构化地址或地理空间检查。

addressing_dictionary

概览

版本

构建

安装

用法

核心流程

已安装对象

运维边界

这个页面对您有帮助吗？