pg_smtp_client

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

概览

扩展包名	版本	分类	许可证	语言
`pg_smtp_client`	`0.2.1`	UTIL	MIT	Rust

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
4170	`pg_smtp_client`	否	是	否	是	否	否	`smtp_client`

相关扩展	`pg_html5_email_address` `emailaddr` `pg_utl_smtp` `omni_email` `uri` `ip4r` `url_encode`

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	PIGSTY	`0.2.1`	1817161514	`pg_smtp_client`	-
RPM	PIGSTY	`0.2.1`	1817161514	`pg_smtp_client_$v`	-
DEB	PIGSTY	`0.2.1`	1817161514	`postgresql-$v-pg-smtp-client`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.2.1 el8.x86_64.pg18 : pg_smtp_client_18 pg_smtp_client_18-0.2.1-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el8.x86_64.pg17 : pg_smtp_client_17 pg_smtp_client_17-0.2.1-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el8.x86_64.pg16 : pg_smtp_client_16 pg_smtp_client_16-0.2.1-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el8.x86_64.pg15 : pg_smtp_client_15 pg_smtp_client_15-0.2.1-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el8.x86_64.pg14 : pg_smtp_client_14 pg_smtp_client_14-0.2.1-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.2.1 · 1.2MiB
el8.aarch64	PIGSTY 0.2.1 el8.aarch64.pg18 : pg_smtp_client_18 pg_smtp_client_18-0.2.1-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 el8.aarch64.pg17 : pg_smtp_client_17 pg_smtp_client_17-0.2.1-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 el8.aarch64.pg16 : pg_smtp_client_16 pg_smtp_client_16-0.2.1-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 el8.aarch64.pg15 : pg_smtp_client_15 pg_smtp_client_15-0.2.1-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 el8.aarch64.pg14 : pg_smtp_client_14 pg_smtp_client_14-0.2.1-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.2.1 · 1.1MiB
el9.x86_64	PIGSTY 0.2.1 el9.x86_64.pg18 : pg_smtp_client_18 pg_smtp_client_18-0.2.1-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.2.1 · 1.3MiB	PIGSTY 0.2.1 el9.x86_64.pg17 : pg_smtp_client_17 pg_smtp_client_17-0.2.1-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.2.1 · 1.3MiB	PIGSTY 0.2.1 el9.x86_64.pg16 : pg_smtp_client_16 pg_smtp_client_16-0.2.1-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.2.1 · 1.3MiB	PIGSTY 0.2.1 el9.x86_64.pg15 : pg_smtp_client_15 pg_smtp_client_15-0.2.1-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el9.x86_64.pg14 : pg_smtp_client_14 pg_smtp_client_14-0.2.1-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.2.1 · 1.2MiB
el9.aarch64	PIGSTY 0.2.1 el9.aarch64.pg18 : pg_smtp_client_18 pg_smtp_client_18-0.2.1-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el9.aarch64.pg17 : pg_smtp_client_17 pg_smtp_client_17-0.2.1-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el9.aarch64.pg16 : pg_smtp_client_16 pg_smtp_client_16-0.2.1-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el9.aarch64.pg15 : pg_smtp_client_15 pg_smtp_client_15-0.2.1-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el9.aarch64.pg14 : pg_smtp_client_14 pg_smtp_client_14-0.2.1-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.2.1 · 1.2MiB
el10.x86_64	PIGSTY 0.2.1 el10.x86_64.pg18 : pg_smtp_client_18 pg_smtp_client_18-0.2.1-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.2.1 · 1.3MiB	PIGSTY 0.2.1 el10.x86_64.pg17 : pg_smtp_client_17 pg_smtp_client_17-0.2.1-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.2.1 · 1.3MiB	PIGSTY 0.2.1 el10.x86_64.pg16 : pg_smtp_client_16 pg_smtp_client_16-0.2.1-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.2.1 · 1.3MiB	PIGSTY 0.2.1 el10.x86_64.pg15 : pg_smtp_client_15 pg_smtp_client_15-0.2.1-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el10.x86_64.pg14 : pg_smtp_client_14 pg_smtp_client_14-0.2.1-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.2.1 · 1.2MiB
el10.aarch64	PIGSTY 0.2.1 el10.aarch64.pg18 : pg_smtp_client_18 pg_smtp_client_18-0.2.1-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el10.aarch64.pg17 : pg_smtp_client_17 pg_smtp_client_17-0.2.1-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el10.aarch64.pg16 : pg_smtp_client_16 pg_smtp_client_16-0.2.1-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el10.aarch64.pg15 : pg_smtp_client_15 pg_smtp_client_15-0.2.1-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.2.1 · 1.2MiB	PIGSTY 0.2.1 el10.aarch64.pg14 : pg_smtp_client_14 pg_smtp_client_14-0.2.1-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.2.1 · 1.2MiB
d12.x86_64	PIGSTY 0.2.1 d12.x86_64.pg18 : postgresql-18-pg-smtp-client postgresql-18-pg-smtp-client_0.2.1-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.2.1 · 1011.2KiB	PIGSTY 0.2.1 d12.x86_64.pg17 : postgresql-17-pg-smtp-client postgresql-17-pg-smtp-client_0.2.1-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.2.1 · 1009.8KiB	PIGSTY 0.2.1 d12.x86_64.pg16 : postgresql-16-pg-smtp-client postgresql-16-pg-smtp-client_0.2.1-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.2.1 · 1009.2KiB	PIGSTY 0.2.1 d12.x86_64.pg15 : postgresql-15-pg-smtp-client postgresql-15-pg-smtp-client_0.2.1-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.2.1 · 1002.9KiB	PIGSTY 0.2.1 d12.x86_64.pg14 : postgresql-14-pg-smtp-client postgresql-14-pg-smtp-client_0.2.1-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.2.1 · 998.7KiB
d12.aarch64	PIGSTY 0.2.1 d12.aarch64.pg18 : postgresql-18-pg-smtp-client postgresql-18-pg-smtp-client_0.2.1-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.2.1 · 862.1KiB	PIGSTY 0.2.1 d12.aarch64.pg17 : postgresql-17-pg-smtp-client postgresql-17-pg-smtp-client_0.2.1-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.2.1 · 860.2KiB	PIGSTY 0.2.1 d12.aarch64.pg16 : postgresql-16-pg-smtp-client postgresql-16-pg-smtp-client_0.2.1-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.2.1 · 859.6KiB	PIGSTY 0.2.1 d12.aarch64.pg15 : postgresql-15-pg-smtp-client postgresql-15-pg-smtp-client_0.2.1-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.2.1 · 855.0KiB	PIGSTY 0.2.1 d12.aarch64.pg14 : postgresql-14-pg-smtp-client postgresql-14-pg-smtp-client_0.2.1-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.2.1 · 853.3KiB
d13.x86_64	PIGSTY 0.2.1 d13.x86_64.pg18 : postgresql-18-pg-smtp-client postgresql-18-pg-smtp-client_0.2.1-3PIGSTY~trixie_amd64.deb PIGSTY · 0.2.1 · 1011.5KiB	PIGSTY 0.2.1 d13.x86_64.pg17 : postgresql-17-pg-smtp-client postgresql-17-pg-smtp-client_0.2.1-3PIGSTY~trixie_amd64.deb PIGSTY · 0.2.1 · 1010.3KiB	PIGSTY 0.2.1 d13.x86_64.pg16 : postgresql-16-pg-smtp-client postgresql-16-pg-smtp-client_0.2.1-3PIGSTY~trixie_amd64.deb PIGSTY · 0.2.1 · 1008.3KiB	PIGSTY 0.2.1 d13.x86_64.pg15 : postgresql-15-pg-smtp-client postgresql-15-pg-smtp-client_0.2.1-3PIGSTY~trixie_amd64.deb PIGSTY · 0.2.1 · 1001.1KiB	PIGSTY 0.2.1 d13.x86_64.pg14 : postgresql-14-pg-smtp-client postgresql-14-pg-smtp-client_0.2.1-3PIGSTY~trixie_amd64.deb PIGSTY · 0.2.1 · 999.5KiB
d13.aarch64	PIGSTY 0.2.1 d13.aarch64.pg18 : postgresql-18-pg-smtp-client postgresql-18-pg-smtp-client_0.2.1-3PIGSTY~trixie_arm64.deb PIGSTY · 0.2.1 · 862.2KiB	PIGSTY 0.2.1 d13.aarch64.pg17 : postgresql-17-pg-smtp-client postgresql-17-pg-smtp-client_0.2.1-3PIGSTY~trixie_arm64.deb PIGSTY · 0.2.1 · 860.9KiB	PIGSTY 0.2.1 d13.aarch64.pg16 : postgresql-16-pg-smtp-client postgresql-16-pg-smtp-client_0.2.1-3PIGSTY~trixie_arm64.deb PIGSTY · 0.2.1 · 860.5KiB	PIGSTY 0.2.1 d13.aarch64.pg15 : postgresql-15-pg-smtp-client postgresql-15-pg-smtp-client_0.2.1-3PIGSTY~trixie_arm64.deb PIGSTY · 0.2.1 · 855.8KiB	PIGSTY 0.2.1 d13.aarch64.pg14 : postgresql-14-pg-smtp-client postgresql-14-pg-smtp-client_0.2.1-3PIGSTY~trixie_arm64.deb PIGSTY · 0.2.1 · 854.0KiB
u22.x86_64	PIGSTY 0.2.1 u22.x86_64.pg18 : postgresql-18-pg-smtp-client postgresql-18-pg-smtp-client_0.2.1-3PIGSTY~jammy_amd64.deb PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 u22.x86_64.pg17 : postgresql-17-pg-smtp-client postgresql-17-pg-smtp-client_0.2.1-3PIGSTY~jammy_amd64.deb PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 u22.x86_64.pg16 : postgresql-16-pg-smtp-client postgresql-16-pg-smtp-client_0.2.1-3PIGSTY~jammy_amd64.deb PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 u22.x86_64.pg15 : postgresql-15-pg-smtp-client postgresql-15-pg-smtp-client_0.2.1-3PIGSTY~jammy_amd64.deb PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 u22.x86_64.pg14 : postgresql-14-pg-smtp-client postgresql-14-pg-smtp-client_0.2.1-3PIGSTY~jammy_amd64.deb PIGSTY · 0.2.1 · 1.1MiB
u22.aarch64	PIGSTY 0.2.1 u22.aarch64.pg18 : postgresql-18-pg-smtp-client postgresql-18-pg-smtp-client_0.2.1-3PIGSTY~jammy_arm64.deb PIGSTY · 0.2.1 · 1019.3KiB	PIGSTY 0.2.1 u22.aarch64.pg17 : postgresql-17-pg-smtp-client postgresql-17-pg-smtp-client_0.2.1-3PIGSTY~jammy_arm64.deb PIGSTY · 0.2.1 · 1018.6KiB	PIGSTY 0.2.1 u22.aarch64.pg16 : postgresql-16-pg-smtp-client postgresql-16-pg-smtp-client_0.2.1-3PIGSTY~jammy_arm64.deb PIGSTY · 0.2.1 · 1017.0KiB	PIGSTY 0.2.1 u22.aarch64.pg15 : postgresql-15-pg-smtp-client postgresql-15-pg-smtp-client_0.2.1-3PIGSTY~jammy_arm64.deb PIGSTY · 0.2.1 · 1011.1KiB	PIGSTY 0.2.1 u22.aarch64.pg14 : postgresql-14-pg-smtp-client postgresql-14-pg-smtp-client_0.2.1-3PIGSTY~jammy_arm64.deb PIGSTY · 0.2.1 · 1009.9KiB
u24.x86_64	PIGSTY 0.2.1 u24.x86_64.pg18 : postgresql-18-pg-smtp-client postgresql-18-pg-smtp-client_0.2.1-3PIGSTY~noble_amd64.deb PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 u24.x86_64.pg17 : postgresql-17-pg-smtp-client postgresql-17-pg-smtp-client_0.2.1-3PIGSTY~noble_amd64.deb PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 u24.x86_64.pg16 : postgresql-16-pg-smtp-client postgresql-16-pg-smtp-client_0.2.1-3PIGSTY~noble_amd64.deb PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 u24.x86_64.pg15 : postgresql-15-pg-smtp-client postgresql-15-pg-smtp-client_0.2.1-3PIGSTY~noble_amd64.deb PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 u24.x86_64.pg14 : postgresql-14-pg-smtp-client postgresql-14-pg-smtp-client_0.2.1-3PIGSTY~noble_amd64.deb PIGSTY · 0.2.1 · 1.1MiB
u24.aarch64	PIGSTY 0.2.1 u24.aarch64.pg18 : postgresql-18-pg-smtp-client postgresql-18-pg-smtp-client_0.2.1-3PIGSTY~noble_arm64.deb PIGSTY · 0.2.1 · 1006.0KiB	PIGSTY 0.2.1 u24.aarch64.pg17 : postgresql-17-pg-smtp-client postgresql-17-pg-smtp-client_0.2.1-3PIGSTY~noble_arm64.deb PIGSTY · 0.2.1 · 1005.0KiB	PIGSTY 0.2.1 u24.aarch64.pg16 : postgresql-16-pg-smtp-client postgresql-16-pg-smtp-client_0.2.1-3PIGSTY~noble_arm64.deb PIGSTY · 0.2.1 · 1003.5KiB	PIGSTY 0.2.1 u24.aarch64.pg15 : postgresql-15-pg-smtp-client postgresql-15-pg-smtp-client_0.2.1-3PIGSTY~noble_arm64.deb PIGSTY · 0.2.1 · 997.7KiB	PIGSTY 0.2.1 u24.aarch64.pg14 : postgresql-14-pg-smtp-client postgresql-14-pg-smtp-client_0.2.1-3PIGSTY~noble_arm64.deb PIGSTY · 0.2.1 · 995.3KiB
u26.x86_64	PIGSTY 0.2.1 u26.x86_64.pg18 : postgresql-18-pg-smtp-client postgresql-18-pg-smtp-client_0.2.1-3PIGSTY~resolute_amd64.deb PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 u26.x86_64.pg17 : postgresql-17-pg-smtp-client postgresql-17-pg-smtp-client_0.2.1-3PIGSTY~resolute_amd64.deb PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 u26.x86_64.pg16 : postgresql-16-pg-smtp-client postgresql-16-pg-smtp-client_0.2.1-3PIGSTY~resolute_amd64.deb PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 u26.x86_64.pg15 : postgresql-15-pg-smtp-client postgresql-15-pg-smtp-client_0.2.1-3PIGSTY~resolute_amd64.deb PIGSTY · 0.2.1 · 1.1MiB	PIGSTY 0.2.1 u26.x86_64.pg14 : postgresql-14-pg-smtp-client postgresql-14-pg-smtp-client_0.2.1-3PIGSTY~resolute_amd64.deb PIGSTY · 0.2.1 · 1.1MiB
u26.aarch64	PIGSTY 0.2.1 u26.aarch64.pg18 : postgresql-18-pg-smtp-client postgresql-18-pg-smtp-client_0.2.1-3PIGSTY~resolute_arm64.deb PIGSTY · 0.2.1 · 1003.3KiB	PIGSTY 0.2.1 u26.aarch64.pg17 : postgresql-17-pg-smtp-client postgresql-17-pg-smtp-client_0.2.1-3PIGSTY~resolute_arm64.deb PIGSTY · 0.2.1 · 1001.9KiB	PIGSTY 0.2.1 u26.aarch64.pg16 : postgresql-16-pg-smtp-client postgresql-16-pg-smtp-client_0.2.1-3PIGSTY~resolute_arm64.deb PIGSTY · 0.2.1 · 1001.1KiB	PIGSTY 0.2.1 u26.aarch64.pg15 : postgresql-15-pg-smtp-client postgresql-15-pg-smtp-client_0.2.1-3PIGSTY~resolute_arm64.deb PIGSTY · 0.2.1 · 994.3KiB	PIGSTY 0.2.1 u26.aarch64.pg14 : postgresql-14-pg-smtp-client postgresql-14-pg-smtp-client_0.2.1-3PIGSTY~resolute_arm64.deb PIGSTY · 0.2.1 · 992.7KiB

构建

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

BASH

pig build pkg pg_smtp_client         # 构建 RPM / DEB 包

安装

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

BASH

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

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

安装

BASH

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

pig

BASH

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

dnf

BASH

dnf install -y pg_smtp_client_18       # PG 18
dnf install -y pg_smtp_client_17       # PG 17
dnf install -y pg_smtp_client_16       # PG 16
dnf install -y pg_smtp_client_15       # PG 15
dnf install -y pg_smtp_client_14       # PG 14

apt

BASH

apt install -y postgresql-18-pg-smtp-client   # PG 18
apt install -y postgresql-17-pg-smtp-client   # PG 17
apt install -y postgresql-16-pg-smtp-client   # PG 16
apt install -y postgresql-15-pg-smtp-client   # PG 15
apt install -y postgresql-14-pg-smtp-client   # PG 14

创建扩展：

SQL

CREATE EXTENSION pg_smtp_client;

用法

启用扩展

连接到 PostgreSQL 并执行以下命令。

SQL

CREATE EXTENSION IF NOT EXISTS pg_smtp_client CASCADE;

使用 smtp_client.send_email() 函数发送电子邮件。

函数参数

参数	类型	说明	系统配置（可选）
subject	text	邮件主题
body	text	邮件正文
html	boolean	正文是否为 HTML 格式（true）或纯文本格式（false）
from_address	text	发件人邮箱地址	`smtp_client.from_address`
recipients	text[]	收件人邮箱地址列表
ccs	text[]	抄送邮箱地址列表
bccs	text[]	密送邮箱地址列表
smtp_server	text	使用的 SMTP 服务器地址	`smtp_client.server`
smtp_port	integer	SMTP 服务器端口	`smtp_client.port`
smtp_tls	boolean	是否使用 TLS 加密	`smtp_client.tls`
smtp_username	text	SMTP 服务器登录用户名	`smtp_client.username`
smtp_password	text	SMTP 服务器登录密码	`smtp_client.password`

默认配置

您可以为上表中标注的部分参数配置系统级默认值，方法如下：

ALTER SYSTEM SET smtp_client.server TO 'smtp.example.com';
ALTER SYSTEM SET smtp_client.port TO 587;
ALTER SYSTEM SET smtp_client.tls TO true;
ALTER SYSTEM SET smtp_client.username TO 'MySmtpUsername';
ALTER SYSTEM SET smtp_client.password TO 'MySmtpPassword';
ALTER SYSTEM SET smtp_client.from_address TO 'from@example.com';
SELECT pg_reload_conf();

使用示例

发送邮件：

SQL

SELECT smtp_client.send_email('test subject', 'test body', false, 'from@example.com', array['to@example.com'], null, null, 'smtp.example.com', 587, true, 'username', 'password');

使用已配置的默认值发送邮件：

SQL

SELECT smtp_client.send_email('test subject', 'test body', false, null, array['to@example.com']);

或者使用命名参数：

SQL

SELECT smtp_client.send_email('test subject', 'test body', recipients => array['to@example.com']);

意见反馈

这个页面对您有帮助吗？

感谢反馈！请告诉我们如何改进。

抱歉给您带来不便。请告诉我们如何改进。