pg_render

使用SQL渲染HTML页面

概览

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

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

相关扩展	`pg_readme` `ddlx` `schedoc` `pgpdf` `pgdd` `meta` `pg_get_functiondef` `pg_dbms_metadata` `pg_catcheck` `pg_query_rewrite`

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	PIGSTY	`0.1.3`	1817161514	`pg_render`	-
RPM	PIGSTY	`0.1.3`	1817161514	`pg_render_$v`	-
DEB	PIGSTY	`0.1.3`	1817161514	`postgresql-$v-pg-render`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.1.3 el8.x86_64.pg18 : pg_render_18 pg_render_18-0.1.3-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB	PIGSTY 0.1.3 el8.x86_64.pg17 : pg_render_17 pg_render_17-0.1.3-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB	PIGSTY 0.1.3 el8.x86_64.pg16 : pg_render_16 pg_render_16-0.1.3-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB	PIGSTY 0.1.3 el8.x86_64.pg15 : pg_render_15 pg_render_15-0.1.3-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB	PIGSTY 0.1.3 el8.x86_64.pg14 : pg_render_14 pg_render_14-0.1.3-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB
el8.aarch64	PIGSTY 0.1.3 el8.aarch64.pg18 : pg_render_18 pg_render_18-0.1.3-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB	PIGSTY 0.1.3 el8.aarch64.pg17 : pg_render_17 pg_render_17-0.1.3-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB	PIGSTY 0.1.3 el8.aarch64.pg16 : pg_render_16 pg_render_16-0.1.3-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB	PIGSTY 0.1.3 el8.aarch64.pg15 : pg_render_15 pg_render_15-0.1.3-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 el8.aarch64.pg14 : pg_render_14 pg_render_14-0.1.3-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.3 · 1.5MiB
el9.x86_64	PIGSTY 0.1.3 el9.x86_64.pg18 : pg_render_18 pg_render_18-0.1.3-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB	PIGSTY 0.1.3 el9.x86_64.pg17 : pg_render_17 pg_render_17-0.1.3-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB	PIGSTY 0.1.3 el9.x86_64.pg16 : pg_render_16 pg_render_16-0.1.3-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB	PIGSTY 0.1.3 el9.x86_64.pg15 : pg_render_15 pg_render_15-0.1.3-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB	PIGSTY 0.1.3 el9.x86_64.pg14 : pg_render_14 pg_render_14-0.1.3-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB
el9.aarch64	PIGSTY 0.1.3 el9.aarch64.pg18 : pg_render_18 pg_render_18-0.1.3-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB	PIGSTY 0.1.3 el9.aarch64.pg17 : pg_render_17 pg_render_17-0.1.3-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB	PIGSTY 0.1.3 el9.aarch64.pg16 : pg_render_16 pg_render_16-0.1.3-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB	PIGSTY 0.1.3 el9.aarch64.pg15 : pg_render_15 pg_render_15-0.1.3-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB	PIGSTY 0.1.3 el9.aarch64.pg14 : pg_render_14 pg_render_14-0.1.3-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB
el10.x86_64	PIGSTY 0.1.3 el10.x86_64.pg18 : pg_render_18 pg_render_18-0.1.3-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB	PIGSTY 0.1.3 el10.x86_64.pg17 : pg_render_17 pg_render_17-0.1.3-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB	PIGSTY 0.1.3 el10.x86_64.pg16 : pg_render_16 pg_render_16-0.1.3-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB	PIGSTY 0.1.3 el10.x86_64.pg15 : pg_render_15 pg_render_15-0.1.3-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB	PIGSTY 0.1.3 el10.x86_64.pg14 : pg_render_14 pg_render_14-0.1.3-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.3 · 1.7MiB
el10.aarch64	PIGSTY 0.1.3 el10.aarch64.pg18 : pg_render_18 pg_render_18-0.1.3-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB	PIGSTY 0.1.3 el10.aarch64.pg17 : pg_render_17 pg_render_17-0.1.3-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB	PIGSTY 0.1.3 el10.aarch64.pg16 : pg_render_16 pg_render_16-0.1.3-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB	PIGSTY 0.1.3 el10.aarch64.pg15 : pg_render_15 pg_render_15-0.1.3-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB	PIGSTY 0.1.3 el10.aarch64.pg14 : pg_render_14 pg_render_14-0.1.3-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.3 · 1.6MiB
d12.x86_64	PIGSTY 0.1.3 d12.x86_64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 d12.x86_64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 d12.x86_64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 d12.x86_64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 d12.x86_64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.3 · 1.4MiB
d12.aarch64	PIGSTY 0.1.3 d12.aarch64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.3 · 1.2MiB	PIGSTY 0.1.3 d12.aarch64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.3 · 1.2MiB	PIGSTY 0.1.3 d12.aarch64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.3 · 1.2MiB	PIGSTY 0.1.3 d12.aarch64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.3 · 1.2MiB	PIGSTY 0.1.3 d12.aarch64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.3 · 1.2MiB
d13.x86_64	PIGSTY 0.1.3 d13.x86_64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-3PIGSTY~trixie_amd64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 d13.x86_64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-3PIGSTY~trixie_amd64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 d13.x86_64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-3PIGSTY~trixie_amd64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 d13.x86_64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-3PIGSTY~trixie_amd64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 d13.x86_64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-3PIGSTY~trixie_amd64.deb PIGSTY · 0.1.3 · 1.3MiB
d13.aarch64	PIGSTY 0.1.3 d13.aarch64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-3PIGSTY~trixie_arm64.deb PIGSTY · 0.1.3 · 1.2MiB	PIGSTY 0.1.3 d13.aarch64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-3PIGSTY~trixie_arm64.deb PIGSTY · 0.1.3 · 1.2MiB	PIGSTY 0.1.3 d13.aarch64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-3PIGSTY~trixie_arm64.deb PIGSTY · 0.1.3 · 1.2MiB	PIGSTY 0.1.3 d13.aarch64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-3PIGSTY~trixie_arm64.deb PIGSTY · 0.1.3 · 1.2MiB	PIGSTY 0.1.3 d13.aarch64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-3PIGSTY~trixie_arm64.deb PIGSTY · 0.1.3 · 1.2MiB
u22.x86_64	PIGSTY 0.1.3 u22.x86_64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-3PIGSTY~jammy_amd64.deb PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 u22.x86_64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-3PIGSTY~jammy_amd64.deb PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 u22.x86_64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-3PIGSTY~jammy_amd64.deb PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 u22.x86_64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-3PIGSTY~jammy_amd64.deb PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 u22.x86_64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-3PIGSTY~jammy_amd64.deb PIGSTY · 0.1.3 · 1.5MiB
u22.aarch64	PIGSTY 0.1.3 u22.aarch64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-3PIGSTY~jammy_arm64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 u22.aarch64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-3PIGSTY~jammy_arm64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 u22.aarch64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-3PIGSTY~jammy_arm64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 u22.aarch64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-3PIGSTY~jammy_arm64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 u22.aarch64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-3PIGSTY~jammy_arm64.deb PIGSTY · 0.1.3 · 1.4MiB
u24.x86_64	PIGSTY 0.1.3 u24.x86_64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-3PIGSTY~noble_amd64.deb PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 u24.x86_64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-3PIGSTY~noble_amd64.deb PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 u24.x86_64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-3PIGSTY~noble_amd64.deb PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 u24.x86_64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-3PIGSTY~noble_amd64.deb PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 u24.x86_64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-3PIGSTY~noble_amd64.deb PIGSTY · 0.1.3 · 1.5MiB
u24.aarch64	PIGSTY 0.1.3 u24.aarch64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-3PIGSTY~noble_arm64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 u24.aarch64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-3PIGSTY~noble_arm64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 u24.aarch64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-3PIGSTY~noble_arm64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 u24.aarch64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-3PIGSTY~noble_arm64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 u24.aarch64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-3PIGSTY~noble_arm64.deb PIGSTY · 0.1.3 · 1.4MiB
u26.x86_64	PIGSTY 0.1.3 u26.x86_64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-3PIGSTY~resolute_amd64.deb PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 u26.x86_64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-3PIGSTY~resolute_amd64.deb PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 u26.x86_64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-3PIGSTY~resolute_amd64.deb PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 u26.x86_64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-3PIGSTY~resolute_amd64.deb PIGSTY · 0.1.3 · 1.5MiB	PIGSTY 0.1.3 u26.x86_64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-3PIGSTY~resolute_amd64.deb PIGSTY · 0.1.3 · 1.5MiB
u26.aarch64	PIGSTY 0.1.3 u26.aarch64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-3PIGSTY~resolute_arm64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 u26.aarch64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-3PIGSTY~resolute_arm64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 u26.aarch64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-3PIGSTY~resolute_arm64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 u26.aarch64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-3PIGSTY~resolute_arm64.deb PIGSTY · 0.1.3 · 1.4MiB	PIGSTY 0.1.3 u26.aarch64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-3PIGSTY~resolute_arm64.deb PIGSTY · 0.1.3 · 1.4MiB

构建

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

BASH

pig build pkg pg_render         # 构建 RPM / DEB 包

安装

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

BASH

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

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

安装

BASH

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

pig

BASH

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

dnf

BASH

dnf install -y pg_render_18       # PG 18
dnf install -y pg_render_17       # PG 17
dnf install -y pg_render_16       # PG 16
dnf install -y pg_render_15       # PG 15
dnf install -y pg_render_14       # PG 14

apt

BASH

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

创建扩展：

SQL

CREATE EXTENSION pg_render;

用法

pg_render: PostgreSQL 的 Liquid 模板渲染

`render(template text, input json|array|value)`

使用 Liquid 语法，用查询结果渲染模板：

SQL

-- 单个值
SELECT render('Total: {{ value }}', (SELECT count(*) FROM posts));

-- 单行多列
SELECT render(
    '<h1>{{ title }}</h1><p>{{ text }}</p>',
    (SELECT to_json(r) FROM (SELECT title, text FROM posts WHERE id = 1) r)
);

-- 遍历数组
SELECT render(
    '{% for v in values %} {{ v }} {% endfor %}',
    (SELECT array(SELECT title FROM posts))
);

-- 遍历多行多列
SELECT render(
    '{% for row in rows %} {{ row.title }} - {{ row.author }} {% endfor %}',
    json_agg(to_json(posts.*))
) FROM posts;

`render_agg(template text, input record|json|value)`

聚合渲染函数 – 为每一行渲染模板：

SQL

-- 从派生表逐行渲染
SELECT render_agg('{{ title }} {{ text }}', props)
FROM (SELECT title, text FROM posts) AS props;

-- 使用 json_build_object 渲染
SELECT render_agg(
    '<article><h1>{{ title }}</h1></article>',
    json_build_object('title', title)
) FROM posts;

使用存储的模板

SQL

SELECT render(
    (SELECT template FROM templates WHERE id = 'my_tpl'),
    (SELECT to_json(r) FROM (SELECT title, text FROM posts WHERE id = 1) r)
);

PostgREST 集成

SQL

CREATE FUNCTION api.index() RETURNS "text/html" AS $$
SELECT render(
    '<html><body><h1>{{ title }}</h1></body></html>',
    (SELECT to_json(r) FROM (SELECT title FROM posts WHERE id = 1) r)
) $$;

意见反馈

这个页面对您有帮助吗？

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

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