UTIL - 工具

实用功能扩展：HTTP请求，GZIP压缩，JWT处理，邮件客户端，正则，字符编码，编码解码，加密解密等实用功能

实用功能扩展：HTTP请求，GZIP压缩，JWT处理，邮件客户端，正则，字符编码，编码解码，加密解密等实用功能

共有 31 个扩展包，包含 32 个扩展。

扩展 包 版本 许可证 语言 描述
gzip pg_gzip 1.0.0 MIT C 使用SQL执行Gzip压缩与解压缩
bzip pg_bzip 1.0.0 MIT C BZIP压缩解压缩函数包
zstd pg_zstd 1.1.2 ISC C ZSTD压缩解压缩函数包
http pg_http 1.7.0 MIT C HTTP客户端，允许在数据库内收发HTTP请求 (supabase)
pg_net pg_net 0.20.2 Apache-2.0 C 用 SQL 进行异步非阻塞HTTP/HTTPS 请求的扩展 (supabase)
pg_curl pg_curl 2.4.5 MIT C 封装CURL，执行各种用URL传输数据的操作
pg_retry pg_retry 1.0.0 PostgreSQL C 在临时错误中使用指数退避重试语句
pgjq pgjq 0.1.0 MIT C 在Postgres中使用jq查询JSON
pgjwt pgjwt 0.2.0 MIT SQL JSON Web Token API 的PG实现 (supabase)
pg_smtp_client pg_smtp_client 0.2.1 MIT Rust 使用SMTP从PostgreSQL内发送邮件的客户端扩展
pg_html5_email_address pg_html5_email_address 1.2.3 PostgreSQL SQL 验证Email是否符合HTML5规范的扩展
url_encode url_encode 1.2.5 PostgreSQL C 提供URL编码解码函数
pgsql_tweaks pgsql_tweaks 1.0.2 PostgreSQL SQL 一些日常会用到的便利函数与视图
pg_extra_time pg_extra_time 2.0.0 PostgreSQL SQL 一些关于日期与时间的扩展函数
pgpcre pgpcre 0.20190509 PostgreSQL C PCRE/Perl风格的正则表达式支持
icu_ext icu_ext 1.10.0 PostgreSQL C 访问ICU库提供的函数
pgqr pgqr 1.0 BSD 3-Clause C 从数据库中直接生成QR二维码
pg_protobuf pg_protobuf 1.0 MIT C 提供Protobuf函数支持
envvar pg_envvar 1.0.1 PostgreSQL C 获取环境变量的函数
floatfile floatfile 1.3.1 MIT C 将浮点数组存储到文件中而不是堆表中
pg_render pg_render 0.1.3 MIT Rust 使用SQL渲染HTML页面
pg_readme pg_readme 0.7.0 PostgreSQL C 为模式与扩展生成Markdown文档
pg_readme_test_extension pg_readme 0.7.0 PostgreSQL C 为模式与扩展生成Markdown文档
ddl_historization ddl_historization 0.0.7 GPL-2.0 SQL 用SQL将所有DDL变更写入到数据库表中
data_historization data_historization 1.1.0 PostgreSQL SQL 用SQL将数据变更历史保存到分区表中
schedoc pg_schedoc 0.0.1 GPL-3.0 SQL 在Django与DBT之间通过注释文档交换元数据
hashlib pg_hashlib 1.1 PostgreSQL C 稳定哈希函数包
xxhash pg_xxhash 0.0.1 BSD 2-Clause C xxhash哈希函数包
shacrypt shacrypt 1.1 PostgreSQL C 实现SHA256-CRYPT与SHA512-CRYPT密钥加密算法
cryptint cryptint 1.0.0 PostgreSQL C 加密INT与BIGINT类型
pguecc pg_ecdsa 1.0 BSD 2-Clause C PostgreSQL的uECC绑定，椭圆曲线加解密函数包
sparql pgsparql 1.0 Apache-2.0 SQL 使用SQL查询SPARQL数据源

gzip - 1.0.0

使用SQL执行Gzip压缩与解压缩

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

bzip - 1.0.0

BZIP压缩解压缩函数包

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

zstd - 1.1.2

ZSTD压缩解压缩函数包

Extension Website Attributes
Package pg_zstd
RPM pg_zstd_$v DDL
DEB postgresql-$v-zstd LIB
Language C
License ISC
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

http - 1.7.0

HTTP客户端，允许在数据库内收发HTTP请求 (supabase)

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

pg_net - 0.20.2

用 SQL 进行异步非阻塞HTTP/HTTPS 请求的扩展 (supabase)

Extension Website Attributes
Package pg_net
RPM pg_net_$v DDL
DEB postgresql-$v-pg-net LIB
Language C
License Apache-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_curl - 2.4.5

封装CURL，执行各种用URL传输数据的操作

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

pg_retry - 1.0.0

在临时错误中使用指数退避重试语句

Extension Website Attributes
Package pg_retry
RPM pg_retry_$v DDL
DEB postgresql-$v-retry LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171817
el918171817
el1018171817
d1218171817
d1318171817
u2218171817
u2418171817

pgjq - 0.1.0

在Postgres中使用jq查询JSON

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

pgjwt - 0.2.0

JSON Web Token API 的PG实现 (supabase)

Extension Website Attributes
Package pgjwt
RPM pgjwt_$v DDL
DEB postgresql-$v-pgjwt LIB
Language SQL TRUST
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_smtp_client - 0.2.1

使用SMTP从PostgreSQL内发送邮件的客户端扩展

Extension Website Attributes
Package pg_smtp_client
RPM pg_smtp_client_$v DDL
DEB postgresql-$v-pg-smtp-client LIB
Language Rust TRUST
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_html5_email_address - 1.2.3

验证Email是否符合HTML5规范的扩展

Extension Website Attributes
Package pg_html5_email_address
RPM pg_html5_email_address_$v DDL
DEB postgresql-$v-pg-html5-email-address
Language SQL
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

url_encode - 1.2.5

提供URL编码解码函数

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

pgsql_tweaks - 1.0.2

一些日常会用到的便利函数与视图

Extension Website Attributes
Package pgsql_tweaks
RPM pgsql_tweaks_$v DDL
DEB postgresql-$v-pgsql-tweaks LIB
Language SQL
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_extra_time - 2.0.0

一些关于日期与时间的扩展函数

Extension Website Attributes
Package pg_extra_time
RPM pg_extra_time_$v DDL
DEB postgresql-$v-pg-extra-time LIB
Language SQL TRUST
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgpcre - 0.20190509

PCRE/Perl风格的正则表达式支持

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

icu_ext - 1.10.0

访问ICU库提供的函数

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

pgqr - 1.0

从数据库中直接生成QR二维码

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

pg_protobuf - 1.0

提供Protobuf函数支持

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

envvar - 1.0.1

获取环境变量的函数

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

floatfile - 1.3.1

将浮点数组存储到文件中而不是堆表中

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

pg_render - 0.1.3

使用SQL渲染HTML页面

Extension Website Attributes
Package pg_render
RPM pg_render_$v DDL
DEB postgresql-$v-pg-render LIB
Language Rust
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_readme - 0.7.0

为模式与扩展生成Markdown文档

Extension Website Attributes
Package pg_readme
RPM pg_readme_$v DDL
DEB postgresql-$v-pg-readme
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

ddl_historization - 0.0.7

用SQL将所有DDL变更写入到数据库表中

Extension Website Attributes
Package ddl_historization
RPM ddl_historization_$v DDL
DEB postgresql-$v-ddl-historization
Language SQL
License GPL-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

data_historization - 1.1.0

用SQL将数据变更历史保存到分区表中

Extension Website Attributes
Package data_historization
RPM data_historization_$v DDL
DEB postgresql-$v-data-historization
Language SQL TRUST
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

schedoc - 0.0.1

在Django与DBT之间通过注释文档交换元数据

Extension Website Attributes
Package pg_schedoc
RPM pg_schedoc_$v DDL
DEB postgresql-$v-pg-schedoc
Language SQL
License GPL-3.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

hashlib - 1.1

稳定哈希函数包

Extension Website Attributes
Package pg_hashlib
RPM pg_hashlib_$v DDL
DEB postgresql-$v-pg-hashlib LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

xxhash - 0.0.1

xxhash哈希函数包

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

shacrypt - 1.1

实现SHA256-CRYPT与SHA512-CRYPT密钥加密算法

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

cryptint - 1.0.0

加密INT与BIGINT类型

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

pguecc - 1.0

PostgreSQL的uECC绑定，椭圆曲线加解密函数包

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

sparql - 1.0

使用SQL查询SPARQL数据源

Extension Website Attributes
Package pgsparql
RPM pgsparql_$v DDL
DEB postgresql-$v-pgsparql
Language SQL
License Apache-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514