pg_render

Render HTML in SQL

Overview

Package	Version	Category	License	Language
`pg_render`	`0.1.3`	UTIL	MIT	Rust

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
4290	`pg_render`	No	Yes	No	Yes	No	No	-

Related	`pg_readme` `ddlx` `schedoc` `pgpdf` `pgdd` `meta` `pg_get_functiondef` `pg_dbms_metadata` `pg_catcheck` `pg_query_rewrite`

Version

Type	Repo	Version	PG Ver	Package	Deps
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

Build

You can build the RPM / DEB packages for pg_render using pig build:

pig build pkg pg_render         # build RPM / DEB packages

Install

You can install pg_render directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

Install

pig install pg_render;          # Install for current active PG version

pig

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

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

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

Create Extension:

CREATE EXTENSION pg_render;

Usage

pg_render: Liquid template rendering for PostgreSQL

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

Render a template with query results using Liquid syntax:

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

-- Multiple columns from one row
SELECT render(
    '<h1>{{ title }}</h1><p>{{ text }}</p>',
    (SELECT to_json(r) FROM (SELECT title, text FROM posts WHERE id = 1) r)
);

-- Loop over an array
SELECT render(
    '{% for v in values %} {{ v }} {% endfor %}',
    (SELECT array(SELECT title FROM posts))
);

-- Loop over multiple rows with multiple columns
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)`

Aggregate render function – renders a template for each row:

-- Render each row from a derived table
SELECT render_agg('{{ title }} {{ text }}', props)
FROM (SELECT title, text FROM posts) AS props;

-- Render using json_build_object
SELECT render_agg(
    '<article><h1>{{ title }}</h1></article>',
    json_build_object('title', title)
) FROM posts;

Using Stored Templates

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 Integration

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)
) $$;

pg_render

Overview

Version

Build

Install

Usage

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

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

Using Stored Templates

PostgREST Integration

Was this page helpful?

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

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