pg_money

精确的带币种金额类型、算术与金额分摊

概览

扩展包名	版本	分类	许可证	语言
`pg_money`	`0.3.0`	TYPE	MIT	Rust

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

相关扩展	`currency` `financial` `pg_rational` `pgmp`

Currency metadata is built in; the currency extension is related, not required.

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	PIGSTY	`0.3.0`	1817161514	`pg_money`	-
RPM	PIGSTY	`0.3.0`	1817161514	`pg_money_$v`	-
DEB	PIGSTY	`0.3.0`	1817161514	`postgresql-$v-pg-money`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.3.0 el8.x86_64.pg18 : pg_money_18 pg_money_18-0.3.0-1PGSTY.el8.x86_64.rpm PIGSTY · 0.3.0 · 1017.7KiB	PIGSTY 0.3.0 el8.x86_64.pg17 : pg_money_17 pg_money_17-0.3.0-1PGSTY.el8.x86_64.rpm PIGSTY · 0.3.0 · 1014.9KiB	PIGSTY 0.3.0 el8.x86_64.pg16 : pg_money_16 pg_money_16-0.3.0-1PGSTY.el8.x86_64.rpm PIGSTY · 0.3.0 · 1013.7KiB	PIGSTY 0.3.0 el8.x86_64.pg15 : pg_money_15 pg_money_15-0.3.0-1PGSTY.el8.x86_64.rpm PIGSTY · 0.3.0 · 1005.9KiB	PIGSTY 0.3.0 el8.x86_64.pg14 : pg_money_14 pg_money_14-0.3.0-1PGSTY.el8.x86_64.rpm PIGSTY · 0.3.0 · 1003.2KiB
el8.aarch64	PIGSTY 0.3.0 el8.aarch64.pg18 : pg_money_18 pg_money_18-0.3.0-1PGSTY.el8.aarch64.rpm PIGSTY · 0.3.0 · 970.7KiB	PIGSTY 0.3.0 el8.aarch64.pg17 : pg_money_17 pg_money_17-0.3.0-1PGSTY.el8.aarch64.rpm PIGSTY · 0.3.0 · 966.9KiB	PIGSTY 0.3.0 el8.aarch64.pg16 : pg_money_16 pg_money_16-0.3.0-1PGSTY.el8.aarch64.rpm PIGSTY · 0.3.0 · 965.8KiB	PIGSTY 0.3.0 el8.aarch64.pg15 : pg_money_15 pg_money_15-0.3.0-1PGSTY.el8.aarch64.rpm PIGSTY · 0.3.0 · 955.8KiB	PIGSTY 0.3.0 el8.aarch64.pg14 : pg_money_14 pg_money_14-0.3.0-1PGSTY.el8.aarch64.rpm PIGSTY · 0.3.0 · 953.8KiB
el9.x86_64	PIGSTY 0.3.0 el9.x86_64.pg18 : pg_money_18 pg_money_18-0.3.0-1PGSTY.el9.x86_64.rpm PIGSTY · 0.3.0 · 1.0MiB	PIGSTY 0.3.0 el9.x86_64.pg17 : pg_money_17 pg_money_17-0.3.0-1PGSTY.el9.x86_64.rpm PIGSTY · 0.3.0 · 1.0MiB	PIGSTY 0.3.0 el9.x86_64.pg16 : pg_money_16 pg_money_16-0.3.0-1PGSTY.el9.x86_64.rpm PIGSTY · 0.3.0 · 1.0MiB	PIGSTY 0.3.0 el9.x86_64.pg15 : pg_money_15 pg_money_15-0.3.0-1PGSTY.el9.x86_64.rpm PIGSTY · 0.3.0 · 1022.4KiB	PIGSTY 0.3.0 el9.x86_64.pg14 : pg_money_14 pg_money_14-0.3.0-1PGSTY.el9.x86_64.rpm PIGSTY · 0.3.0 · 1019.8KiB
el9.aarch64	PIGSTY 0.3.0 el9.aarch64.pg18 : pg_money_18 pg_money_18-0.3.0-1PGSTY.el9.aarch64.rpm PIGSTY · 0.3.0 · 1.0MiB	PIGSTY 0.3.0 el9.aarch64.pg17 : pg_money_17 pg_money_17-0.3.0-1PGSTY.el9.aarch64.rpm PIGSTY · 0.3.0 · 1.0MiB	PIGSTY 0.3.0 el9.aarch64.pg16 : pg_money_16 pg_money_16-0.3.0-1PGSTY.el9.aarch64.rpm PIGSTY · 0.3.0 · 1.0MiB	PIGSTY 0.3.0 el9.aarch64.pg15 : pg_money_15 pg_money_15-0.3.0-1PGSTY.el9.aarch64.rpm PIGSTY · 0.3.0 · 1.0MiB	PIGSTY 0.3.0 el9.aarch64.pg14 : pg_money_14 pg_money_14-0.3.0-1PGSTY.el9.aarch64.rpm PIGSTY · 0.3.0 · 1021.9KiB
el10.x86_64	PIGSTY 0.3.0 el10.x86_64.pg18 : pg_money_18 pg_money_18-0.3.0-1PGSTY.el10.x86_64.rpm PIGSTY · 0.3.0 · 1.0MiB	PIGSTY 0.3.0 el10.x86_64.pg17 : pg_money_17 pg_money_17-0.3.0-1PGSTY.el10.x86_64.rpm PIGSTY · 0.3.0 · 1.0MiB	PIGSTY 0.3.0 el10.x86_64.pg16 : pg_money_16 pg_money_16-0.3.0-1PGSTY.el10.x86_64.rpm PIGSTY · 0.3.0 · 1.0MiB	PIGSTY 0.3.0 el10.x86_64.pg15 : pg_money_15 pg_money_15-0.3.0-1PGSTY.el10.x86_64.rpm PIGSTY · 0.3.0 · 1023.4KiB	PIGSTY 0.3.0 el10.x86_64.pg14 : pg_money_14 pg_money_14-0.3.0-1PGSTY.el10.x86_64.rpm PIGSTY · 0.3.0 · 1021.1KiB
el10.aarch64	PIGSTY 0.3.0 el10.aarch64.pg18 : pg_money_18 pg_money_18-0.3.0-1PGSTY.el10.aarch64.rpm PIGSTY · 0.3.0 · 1018.1KiB	PIGSTY 0.3.0 el10.aarch64.pg17 : pg_money_17 pg_money_17-0.3.0-1PGSTY.el10.aarch64.rpm PIGSTY · 0.3.0 · 1017.6KiB	PIGSTY 0.3.0 el10.aarch64.pg16 : pg_money_16 pg_money_16-0.3.0-1PGSTY.el10.aarch64.rpm PIGSTY · 0.3.0 · 1019.0KiB	PIGSTY 0.3.0 el10.aarch64.pg15 : pg_money_15 pg_money_15-0.3.0-1PGSTY.el10.aarch64.rpm PIGSTY · 0.3.0 · 1015.3KiB	PIGSTY 0.3.0 el10.aarch64.pg14 : pg_money_14 pg_money_14-0.3.0-1PGSTY.el10.aarch64.rpm PIGSTY · 0.3.0 · 1013.7KiB
d12.x86_64	PIGSTY 0.3.0 d12.x86_64.pg18 : postgresql-18-pg-money postgresql-18-pg-money_0.3.0-1PGSTY~bookworm_amd64.deb PIGSTY · 0.3.0 · 853.1KiB	PIGSTY 0.3.0 d12.x86_64.pg17 : postgresql-17-pg-money postgresql-17-pg-money_0.3.0-1PGSTY~bookworm_amd64.deb PIGSTY · 0.3.0 · 851.0KiB	PIGSTY 0.3.0 d12.x86_64.pg16 : postgresql-16-pg-money postgresql-16-pg-money_0.3.0-1PGSTY~bookworm_amd64.deb PIGSTY · 0.3.0 · 850.8KiB	PIGSTY 0.3.0 d12.x86_64.pg15 : postgresql-15-pg-money postgresql-15-pg-money_0.3.0-1PGSTY~bookworm_amd64.deb PIGSTY · 0.3.0 · 845.1KiB	PIGSTY 0.3.0 d12.x86_64.pg14 : postgresql-14-pg-money postgresql-14-pg-money_0.3.0-1PGSTY~bookworm_amd64.deb PIGSTY · 0.3.0 · 845.0KiB
d12.aarch64	PIGSTY 0.3.0 d12.aarch64.pg18 : postgresql-18-pg-money postgresql-18-pg-money_0.3.0-1PGSTY~bookworm_arm64.deb PIGSTY · 0.3.0 · 790.0KiB	PIGSTY 0.3.0 d12.aarch64.pg17 : postgresql-17-pg-money postgresql-17-pg-money_0.3.0-1PGSTY~bookworm_arm64.deb PIGSTY · 0.3.0 · 788.6KiB	PIGSTY 0.3.0 d12.aarch64.pg16 : postgresql-16-pg-money postgresql-16-pg-money_0.3.0-1PGSTY~bookworm_arm64.deb PIGSTY · 0.3.0 · 787.8KiB	PIGSTY 0.3.0 d12.aarch64.pg15 : postgresql-15-pg-money postgresql-15-pg-money_0.3.0-1PGSTY~bookworm_arm64.deb PIGSTY · 0.3.0 · 782.7KiB	PIGSTY 0.3.0 d12.aarch64.pg14 : postgresql-14-pg-money postgresql-14-pg-money_0.3.0-1PGSTY~bookworm_arm64.deb PIGSTY · 0.3.0 · 783.5KiB
d13.x86_64	PIGSTY 0.3.0 d13.x86_64.pg18 : postgresql-18-pg-money postgresql-18-pg-money_0.3.0-1PGSTY~trixie_amd64.deb PIGSTY · 0.3.0 · 853.2KiB	PIGSTY 0.3.0 d13.x86_64.pg17 : postgresql-17-pg-money postgresql-17-pg-money_0.3.0-1PGSTY~trixie_amd64.deb PIGSTY · 0.3.0 · 851.4KiB	PIGSTY 0.3.0 d13.x86_64.pg16 : postgresql-16-pg-money postgresql-16-pg-money_0.3.0-1PGSTY~trixie_amd64.deb PIGSTY · 0.3.0 · 850.8KiB	PIGSTY 0.3.0 d13.x86_64.pg15 : postgresql-15-pg-money postgresql-15-pg-money_0.3.0-1PGSTY~trixie_amd64.deb PIGSTY · 0.3.0 · 845.1KiB	PIGSTY 0.3.0 d13.x86_64.pg14 : postgresql-14-pg-money postgresql-14-pg-money_0.3.0-1PGSTY~trixie_amd64.deb PIGSTY · 0.3.0 · 845.2KiB
d13.aarch64	PIGSTY 0.3.0 d13.aarch64.pg18 : postgresql-18-pg-money postgresql-18-pg-money_0.3.0-1PGSTY~trixie_arm64.deb PIGSTY · 0.3.0 · 791.2KiB	PIGSTY 0.3.0 d13.aarch64.pg17 : postgresql-17-pg-money postgresql-17-pg-money_0.3.0-1PGSTY~trixie_arm64.deb PIGSTY · 0.3.0 · 789.2KiB	PIGSTY 0.3.0 d13.aarch64.pg16 : postgresql-16-pg-money postgresql-16-pg-money_0.3.0-1PGSTY~trixie_arm64.deb PIGSTY · 0.3.0 · 788.6KiB	PIGSTY 0.3.0 d13.aarch64.pg15 : postgresql-15-pg-money postgresql-15-pg-money_0.3.0-1PGSTY~trixie_arm64.deb PIGSTY · 0.3.0 · 783.5KiB	PIGSTY 0.3.0 d13.aarch64.pg14 : postgresql-14-pg-money postgresql-14-pg-money_0.3.0-1PGSTY~trixie_arm64.deb PIGSTY · 0.3.0 · 784.1KiB
u22.x86_64	PIGSTY 0.3.0 u22.x86_64.pg18 : postgresql-18-pg-money postgresql-18-pg-money_0.3.0-1PGSTY~jammy_amd64.deb PIGSTY · 0.3.0 · 951.8KiB	PIGSTY 0.3.0 u22.x86_64.pg17 : postgresql-17-pg-money postgresql-17-pg-money_0.3.0-1PGSTY~jammy_amd64.deb PIGSTY · 0.3.0 · 947.9KiB	PIGSTY 0.3.0 u22.x86_64.pg16 : postgresql-16-pg-money postgresql-16-pg-money_0.3.0-1PGSTY~jammy_amd64.deb PIGSTY · 0.3.0 · 948.9KiB	PIGSTY 0.3.0 u22.x86_64.pg15 : postgresql-15-pg-money postgresql-15-pg-money_0.3.0-1PGSTY~jammy_amd64.deb PIGSTY · 0.3.0 · 939.6KiB	PIGSTY 0.3.0 u22.x86_64.pg14 : postgresql-14-pg-money postgresql-14-pg-money_0.3.0-1PGSTY~jammy_amd64.deb PIGSTY · 0.3.0 · 938.9KiB
u22.aarch64	PIGSTY 0.3.0 u22.aarch64.pg18 : postgresql-18-pg-money postgresql-18-pg-money_0.3.0-1PGSTY~jammy_arm64.deb PIGSTY · 0.3.0 · 921.0KiB	PIGSTY 0.3.0 u22.aarch64.pg17 : postgresql-17-pg-money postgresql-17-pg-money_0.3.0-1PGSTY~jammy_arm64.deb PIGSTY · 0.3.0 · 920.5KiB	PIGSTY 0.3.0 u22.aarch64.pg16 : postgresql-16-pg-money postgresql-16-pg-money_0.3.0-1PGSTY~jammy_arm64.deb PIGSTY · 0.3.0 · 920.5KiB	PIGSTY 0.3.0 u22.aarch64.pg15 : postgresql-15-pg-money postgresql-15-pg-money_0.3.0-1PGSTY~jammy_arm64.deb PIGSTY · 0.3.0 · 917.5KiB	PIGSTY 0.3.0 u22.aarch64.pg14 : postgresql-14-pg-money postgresql-14-pg-money_0.3.0-1PGSTY~jammy_arm64.deb PIGSTY · 0.3.0 · 918.0KiB
u24.x86_64	PIGSTY 0.3.0 u24.x86_64.pg18 : postgresql-18-pg-money postgresql-18-pg-money_0.3.0-1PGSTY~noble_amd64.deb PIGSTY · 0.3.0 · 927.8KiB	PIGSTY 0.3.0 u24.x86_64.pg17 : postgresql-17-pg-money postgresql-17-pg-money_0.3.0-1PGSTY~noble_amd64.deb PIGSTY · 0.3.0 · 925.5KiB	PIGSTY 0.3.0 u24.x86_64.pg16 : postgresql-16-pg-money postgresql-16-pg-money_0.3.0-1PGSTY~noble_amd64.deb PIGSTY · 0.3.0 · 927.9KiB	PIGSTY 0.3.0 u24.x86_64.pg15 : postgresql-15-pg-money postgresql-15-pg-money_0.3.0-1PGSTY~noble_amd64.deb PIGSTY · 0.3.0 · 921.1KiB	PIGSTY 0.3.0 u24.x86_64.pg14 : postgresql-14-pg-money postgresql-14-pg-money_0.3.0-1PGSTY~noble_amd64.deb PIGSTY · 0.3.0 · 921.9KiB
u24.aarch64	PIGSTY 0.3.0 u24.aarch64.pg18 : postgresql-18-pg-money postgresql-18-pg-money_0.3.0-1PGSTY~noble_arm64.deb PIGSTY · 0.3.0 · 914.2KiB	PIGSTY 0.3.0 u24.aarch64.pg17 : postgresql-17-pg-money postgresql-17-pg-money_0.3.0-1PGSTY~noble_arm64.deb PIGSTY · 0.3.0 · 912.6KiB	PIGSTY 0.3.0 u24.aarch64.pg16 : postgresql-16-pg-money postgresql-16-pg-money_0.3.0-1PGSTY~noble_arm64.deb PIGSTY · 0.3.0 · 913.2KiB	PIGSTY 0.3.0 u24.aarch64.pg15 : postgresql-15-pg-money postgresql-15-pg-money_0.3.0-1PGSTY~noble_arm64.deb PIGSTY · 0.3.0 · 911.1KiB	PIGSTY 0.3.0 u24.aarch64.pg14 : postgresql-14-pg-money postgresql-14-pg-money_0.3.0-1PGSTY~noble_arm64.deb PIGSTY · 0.3.0 · 911.5KiB
u26.x86_64	PIGSTY 0.3.0 u26.x86_64.pg18 : postgresql-18-pg-money postgresql-18-pg-money_0.3.0-1PGSTY~resolute_amd64.deb PIGSTY · 0.3.0 · 924.0KiB	PIGSTY 0.3.0 u26.x86_64.pg17 : postgresql-17-pg-money postgresql-17-pg-money_0.3.0-1PGSTY~resolute_amd64.deb PIGSTY · 0.3.0 · 923.4KiB	PIGSTY 0.3.0 u26.x86_64.pg16 : postgresql-16-pg-money postgresql-16-pg-money_0.3.0-1PGSTY~resolute_amd64.deb PIGSTY · 0.3.0 · 923.5KiB	PIGSTY 0.3.0 u26.x86_64.pg15 : postgresql-15-pg-money postgresql-15-pg-money_0.3.0-1PGSTY~resolute_amd64.deb PIGSTY · 0.3.0 · 918.7KiB	PIGSTY 0.3.0 u26.x86_64.pg14 : postgresql-14-pg-money postgresql-14-pg-money_0.3.0-1PGSTY~resolute_amd64.deb PIGSTY · 0.3.0 · 919.1KiB
u26.aarch64	PIGSTY 0.3.0 u26.aarch64.pg18 : postgresql-18-pg-money postgresql-18-pg-money_0.3.0-1PGSTY~resolute_arm64.deb PIGSTY · 0.3.0 · 910.7KiB	PIGSTY 0.3.0 u26.aarch64.pg17 : postgresql-17-pg-money postgresql-17-pg-money_0.3.0-1PGSTY~resolute_arm64.deb PIGSTY · 0.3.0 · 908.6KiB	PIGSTY 0.3.0 u26.aarch64.pg16 : postgresql-16-pg-money postgresql-16-pg-money_0.3.0-1PGSTY~resolute_arm64.deb PIGSTY · 0.3.0 · 908.8KiB	PIGSTY 0.3.0 u26.aarch64.pg15 : postgresql-15-pg-money postgresql-15-pg-money_0.3.0-1PGSTY~resolute_arm64.deb PIGSTY · 0.3.0 · 908.1KiB	PIGSTY 0.3.0 u26.aarch64.pg14 : postgresql-14-pg-money postgresql-14-pg-money_0.3.0-1PGSTY~resolute_arm64.deb PIGSTY · 0.3.0 · 908.9KiB

构建

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

pig build pkg pg_money         # 构建 RPM / DEB 包

安装

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

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

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

安装

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

pig

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

dnf

dnf install -y pg_money_18       # PG 18
dnf install -y pg_money_17       # PG 17
dnf install -y pg_money_16       # PG 16
dnf install -y pg_money_15       # PG 15
dnf install -y pg_money_14       # PG 14

apt

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

创建扩展：

CREATE EXTENSION pg_money;

用法

来源：

pg_money 在 PostgreSQL 14–18 中提供精确的带币种金额、算术、舍入与分摊功能，其类型独立于受区域设置影响的内置金额类型。

核心工作流

CREATE EXTENSION pg_money;
CREATE TABLE invoices (id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
                       total money_with_currency NOT NULL);
INSERT INTO invoices(total) VALUES ('USD 19.95'), (money_make(5.25, 'USD'));
SELECT sum(total), avg(total), money_format(sum(total)) FROM invoices;
SELECT money_split('USD 10.00', 3);
SELECT money_exchange('USD 100', 'EUR', 0.85);

对象与语义

money_with_currency 将币种与精确十进制金额一起存储，money_minor 处理最小货币单位金额。money_make、money_from_minor 和 money_minor_make 用于构造值。money_round 接受明确的舍入模式，money_split 在保持总额不变的前提下分配余数。

算术和聚合会拒绝不兼容币种，不会隐式兑换。汇率须显式提供，或由 money_exchange_at 从应用管理的表中读取；扩展不获取市场行情。应在应用边界检查舍入和金额范围。

运行

0.3.0 控制文件要求超级用户安装，并允许重定位，无需预加载。应将汇率表和修改权限与只读算术区分管理；SQL 输入本身不能证明汇率正确或及时。

pg_money

概览

版本

构建

安装

用法

核心工作流

对象与语义

运行

这个页面对您有帮助吗？