TYPE - 数据类型

自定义类型扩展：前缀树，语义版本号，SI单位，位图，无符号整型，高精度数值，有理数，哈希值，IP地址段，球面，RRULE等

自定义类型扩展：前缀树，语义版本号，SI单位，位图，无符号整型，高精度数值，有理数，哈希值，IP地址段，球面，RRULE等

共有 36 个扩展包，包含 37 个扩展。

扩展 包 版本 许可证 语言 描述
prefix pg_prefix 1.2.10 PostgreSQL C 前缀树数据类型
semver pg_semver 0.41.0 PostgreSQL C 语义版本号数据类型
unit pgunit 7.10 GPL-2.0 C SI 国标单位扩展
pgpdf pgpdf 0.1.0 GPL-3.0 C PDF数据类型，管理函数与全文检索
pglite_fusion pglite_fusion 0.0.6 MIT Rust 在PG表中嵌入SQLite数据库作为数据类型
md5hash md5hash 1.0.1 BSD 2-Clause C 提供128位MD5的原生数据类型
asn1oid asn1oid 1.6 GPL-3.0 C ASN1OID数据类型支持
roaringbitmap pg_roaringbitmap 1.1.0 Apache-2.0 C 支持RoaringBitmap数据类型
pgfaceting pgfaceting 0.2.0 BSD 3-Clause SQL 使用倒排索引的高速切面查询
pg_sphere pgsphere 1.5.2 BSD 3-Clause C 球面对象函数、运算符与索引支持
country pg_country 0.0.3 PostgreSQL C 国家代码数据类型，遵循ISO 3166-1标准
pg_xenophile pg_xenophile 0.8.3 PostgreSQL SQL PostgreSQL i8n与l10n工具包
l10n_table_dependent_extension pg_xenophile 0.8.3 PostgreSQL SQL PostgreSQL l10n 工具包
currency pg_currency 0.0.3 MIT C 使用1字节表示的货币数据类型
collection pgcollection 1.1.1 Apache-2.0 C 在PlPGSQL中使用的内存优化高性能集合数据结构
pgmp pgmp 1.0.5 LGPL-3.0 C 多精度算术扩展
numeral numeral 1.3 GPL-2.0 C 数值类型扩展
pg_rational pg_rational 0.0.2 MIT C 使用BIGINT表示的有理数数据类型
uint pguint 1.20250815 PostgreSQL C 无符号整型数据类型
uint128 pg_uint128 1.2.0 PostgreSQL C 原生128位无符号整型数据类型
hashtypes hashtypes 0.1.5 PostgreSQL C 包括SHA1，MD5在内的多种哈希数据类型
ip4r ip4r 2.4.2 PostgreSQL C PostgreSQL 的 IPv4/v6 和 IPv4/v6 范围索引类型
pg_duration pg_duration 1.0.2 MIT C 用于表示时间段的强化数据类型
uri pg_uri 1.20251029 PostgreSQL C URI数据类型
emailaddr pg_emailaddr 0 PostgreSQL C Email地址数据类型
acl pg_acl 1.0.4 BSD 2-Clause C ACL数据类型
debversion debversion 1.2.0 PostgreSQL SQL Debian版本号数据类型
pg_rrule pg_rrule 0.3.0 MIT C 日历重复规则RRULE数据类型
timestamp9 timestamp9 1.4.0 MIT C 纳秒分辨率时间戳
chkpass chkpass 1.0 PostgreSQL C 数据类型：自动加密的密码
isn isn 1.2 PostgreSQL C 用于国际产品编号标准的数据类型
seg seg 1.4 PostgreSQL C 表示线段或浮点间隔的数据类型
cube cube 1.5 PostgreSQL C 用于存储多维立方体的数据类型
ltree ltree 1.3 PostgreSQL C 用于表示分层树状结构的数据类型
hstore hstore 1.8 PostgreSQL C 用于存储（键，值）对集合的数据类型
citext citext 1.6 PostgreSQL C 提供大小写不敏感的字符串类型
xml2 xml2 1.1 PostgreSQL C XPath 查询和 XSLT

prefix - 1.2.10

前缀树数据类型

Extension Website Attributes
Package pg_prefix
RPM prefix_$v DDL
DEB postgresql-$v-prefix LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

semver - 0.41.0

语义版本号数据类型

Extension Website Attributes
Package pg_semver
RPM semver_$v DDL
DEB postgresql-$v-semver LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

unit - 7.10

SI 国标单位扩展

Extension Website Attributes
Package pgunit
RPM postgresql-unit_$v DDL
DEB postgresql-$v-unit LIB
Language C
License GPL-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgpdf - 0.1.0

PDF数据类型，管理函数与全文检索

Extension Website Attributes
Package pgpdf
RPM pgpdf_$v DDL
DEB postgresql-$v-pgpdf LIB
Language C TRUST
License GPL-3.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pglite_fusion - 0.0.6

在PG表中嵌入SQLite数据库作为数据类型

Extension Website Attributes
Package pglite_fusion
RPM pglite_fusion_$v DDL
DEB postgresql-$v-pglite-fusion LIB
Language Rust
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

md5hash - 1.0.1

提供128位MD5的原生数据类型

Extension Website Attributes
Package md5hash
RPM md5hash_$v DDL
DEB postgresql-$v-md5hash LIB
Language C
License BSD 2-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

asn1oid - 1.6

ASN1OID数据类型支持

Extension Website Attributes
Package asn1oid
RPM asn1oid_$v DDL
DEB postgresql-$v-asn1oid LIB
Language C
License GPL-3.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

roaringbitmap - 1.1.0

支持RoaringBitmap数据类型

Extension Website Attributes
Package pg_roaringbitmap
RPM pg_roaringbitmap_$v DDL
DEB postgresql-$v-roaringbitmap LIB
Language C
License Apache-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgfaceting - 0.2.0

使用倒排索引的高速切面查询

Extension Website Attributes
Package pgfaceting
RPM pgfaceting_$v DDL
DEB postgresql-$v-pgfaceting
Language SQL TRUST
License BSD 3-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_sphere - 1.5.2

球面对象函数、运算符与索引支持

Extension Website Attributes
Package pgsphere
RPM pgsphere_$v DDL
DEB postgresql-$v-pgsphere LIB
Language C
License BSD 3-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

country - 0.0.3

国家代码数据类型，遵循ISO 3166-1标准

Extension Website Attributes
Package pg_country
RPM pg_country_$v DDL
DEB postgresql-$v-pg-country LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_xenophile - 0.8.3

PostgreSQL i8n与l10n工具包

Extension Website Attributes
Package pg_xenophile
RPM pg_xenophile_$v DDL
DEB postgresql-$v-pg-xenophile
Language SQL
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

currency - 0.0.3

使用1字节表示的货币数据类型

Extension Website Attributes
Package pg_currency
RPM pg_currency_$v DDL
DEB postgresql-$v-pg-currency LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

collection - 1.1.1

在PlPGSQL中使用的内存优化高性能集合数据结构

Extension Website Attributes
Package pgcollection
RPM pgcollection_$v DDL
DEB postgresql-$v-collection LIB
Language C
License Apache-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgmp - 1.0.5

多精度算术扩展

Extension Website Attributes
Package pgmp
RPM pgmp_$v DDL
DEB postgresql-$v-pgmp LIB
Language C
License LGPL-3.0
OS/Archx86_64aarch64
el818171615141817161514
el9181716151817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

numeral - 1.3

数值类型扩展

Extension Website Attributes
Package numeral
RPM numeral_$v DDL
DEB postgresql-$v-numeral LIB
Language C
License GPL-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_rational - 0.0.2

使用BIGINT表示的有理数数据类型

Extension Website Attributes
Package pg_rational
RPM pg_rational_$v DDL
DEB postgresql-$v-rational LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

uint - 1.20250815

无符号整型数据类型

Extension Website Attributes
Package pguint
RPM pguint_$v DDL
DEB postgresql-$v-pguint LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

uint128 - 1.2.0

原生128位无符号整型数据类型

Extension Website Attributes
Package pg_uint128
RPM pg_uint128_$v DDL
DEB postgresql-$v-pg-uint128 LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

hashtypes - 0.1.5

包括SHA1，MD5在内的多种哈希数据类型

Extension Website Attributes
Package hashtypes
RPM hashtypes_$v DDL
DEB postgresql-$v-hashtypes LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

ip4r - 2.4.2

PostgreSQL 的 IPv4/v6 和 IPv4/v6 范围索引类型

Extension Website Attributes
Package ip4r
RPM ip4r_$v DDL
DEB postgresql-$v-ip4r LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_duration - 1.0.2

用于表示时间段的强化数据类型

Extension Website Attributes
Package pg_duration
RPM pg_duration_$v DDL
DEB postgresql-$v-pg-duration LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171817
el918171817
el1018171817
d1218171817
d1318171817
u2218171817
u2418171817

uri - 1.20251029

URI数据类型

Extension Website Attributes
Package pg_uri
RPM pg_uri_$v DDL
DEB postgresql-$v-pg-uri LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

emailaddr - 0

Email地址数据类型

Extension Website Attributes
Package pg_emailaddr
RPM pg_emailaddr_$v DDL
DEB postgresql-$v-pg-emailaddr LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

acl - 1.0.4

ACL数据类型

Extension Website Attributes
Package pg_acl
RPM acl_$v DDL
DEB postgresql-$v-acl LIB
Language C
License BSD 2-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

debversion - 1.2.0

Debian版本号数据类型

Extension Website Attributes
Package debversion
RPM - DDL
DEB postgresql-$v-debversion LIB
Language SQL
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_rrule - 0.3.0

日历重复规则RRULE数据类型

Extension Website Attributes
Package pg_rrule
RPM pg_rrule_$v DDL
DEB postgresql-$v-pg-rrule LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

timestamp9 - 1.4.0

纳秒分辨率时间戳

Extension Website Attributes
Package timestamp9
RPM timestamp9_$v DDL
DEB postgresql-$v-timestamp9 LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

chkpass - 1.0

数据类型：自动加密的密码

Extension Website Attributes
Package chkpass
RPM chkpass_$v DDL
DEB postgresql-$v-chkpass LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

isn - 1.2

用于国际产品编号标准的数据类型

Extension Website Attributes
Package isn
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

seg - 1.4

表示线段或浮点间隔的数据类型

Extension Website Attributes
Package seg
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

cube - 1.5

用于存储多维立方体的数据类型

Extension Website Attributes
Package cube
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

ltree - 1.3

用于表示分层树状结构的数据类型

Extension Website Attributes
Package ltree
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

hstore - 1.8

用于存储（键，值）对集合的数据类型

Extension Website Attributes
Package hstore
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

citext - 1.6

提供大小写不敏感的字符串类型

Extension Website Attributes
Package citext
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

xml2 - 1.1

XPath 查询和 XSLT

Extension Website Attributes
Package xml2
RPM postgresql$v-contrib DDL
DEB postgresql-$v
Language C
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24