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_html5_email_address` `pg_readme` `gzip` `bzip` `zstd` `http` `pg_net` `pg_curl`

manual updated pgrx by Vonng

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-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB	PIGSTY 0.1.3 el8.x86_64.pg17 : pg_render_17 pg_render_17-0.1.3-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB	PIGSTY 0.1.3 el8.x86_64.pg16 : pg_render_16 pg_render_16-0.1.3-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB	PIGSTY 0.1.3 el8.x86_64.pg15 : pg_render_15 pg_render_15-0.1.3-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB	PIGSTY 0.1.3 el8.x86_64.pg14 : pg_render_14 pg_render_14-0.1.3-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB
el8.aarch64	PIGSTY 0.1.3 el8.aarch64.pg18 : pg_render_18 pg_render_18-0.1.3-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.3 · 906.8KiB	PIGSTY 0.1.3 el8.aarch64.pg17 : pg_render_17 pg_render_17-0.1.3-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.3 · 907.6KiB	PIGSTY 0.1.3 el8.aarch64.pg16 : pg_render_16 pg_render_16-0.1.3-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.3 · 907.6KiB	PIGSTY 0.1.3 el8.aarch64.pg15 : pg_render_15 pg_render_15-0.1.3-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.3 · 907.9KiB	PIGSTY 0.1.3 el8.aarch64.pg14 : pg_render_14 pg_render_14-0.1.3-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.3 · 907.0KiB
el9.x86_64	PIGSTY 0.1.3 el9.x86_64.pg18 : pg_render_18 pg_render_18-0.1.3-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB	PIGSTY 0.1.3 el9.x86_64.pg17 : pg_render_17 pg_render_17-0.1.3-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB	PIGSTY 0.1.3 el9.x86_64.pg16 : pg_render_16 pg_render_16-0.1.3-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB	PIGSTY 0.1.3 el9.x86_64.pg15 : pg_render_15 pg_render_15-0.1.3-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB	PIGSTY 0.1.3 el9.x86_64.pg14 : pg_render_14 pg_render_14-0.1.3-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB
el9.aarch64	PIGSTY 0.1.3 el9.aarch64.pg18 : pg_render_18 pg_render_18-0.1.3-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.3 · 970.5KiB	PIGSTY 0.1.3 el9.aarch64.pg17 : pg_render_17 pg_render_17-0.1.3-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.3 · 975.5KiB	PIGSTY 0.1.3 el9.aarch64.pg16 : pg_render_16 pg_render_16-0.1.3-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.3 · 970.7KiB	PIGSTY 0.1.3 el9.aarch64.pg15 : pg_render_15 pg_render_15-0.1.3-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.3 · 971.1KiB	PIGSTY 0.1.3 el9.aarch64.pg14 : pg_render_14 pg_render_14-0.1.3-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.3 · 970.9KiB
el10.x86_64	PIGSTY 0.1.3 el10.x86_64.pg18 : pg_render_18 pg_render_18-0.1.3-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB	PIGSTY 0.1.3 el10.x86_64.pg17 : pg_render_17 pg_render_17-0.1.3-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB	PIGSTY 0.1.3 el10.x86_64.pg16 : pg_render_16 pg_render_16-0.1.3-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB	PIGSTY 0.1.3 el10.x86_64.pg15 : pg_render_15 pg_render_15-0.1.3-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB	PIGSTY 0.1.3 el10.x86_64.pg14 : pg_render_14 pg_render_14-0.1.3-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.3 · 1.1MiB
el10.aarch64	PIGSTY 0.1.3 el10.aarch64.pg18 : pg_render_18 pg_render_18-0.1.3-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.3 · 988.4KiB	PIGSTY 0.1.3 el10.aarch64.pg17 : pg_render_17 pg_render_17-0.1.3-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.3 · 988.6KiB	PIGSTY 0.1.3 el10.aarch64.pg16 : pg_render_16 pg_render_16-0.1.3-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.3 · 988.5KiB	PIGSTY 0.1.3 el10.aarch64.pg15 : pg_render_15 pg_render_15-0.1.3-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.3 · 988.7KiB	PIGSTY 0.1.3 el10.aarch64.pg14 : pg_render_14 pg_render_14-0.1.3-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.3 · 988.7KiB
d12.x86_64	PIGSTY 0.1.3 d12.x86_64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.3 · 903.5KiB	PIGSTY 0.1.3 d12.x86_64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.3 · 905.2KiB	PIGSTY 0.1.3 d12.x86_64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.3 · 902.8KiB	PIGSTY 0.1.3 d12.x86_64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.3 · 904.6KiB	PIGSTY 0.1.3 d12.x86_64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.3 · 903.8KiB
d12.aarch64	PIGSTY 0.1.3 d12.aarch64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.3 · 709.4KiB	PIGSTY 0.1.3 d12.aarch64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.3 · 709.5KiB	PIGSTY 0.1.3 d12.aarch64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.3 · 709.5KiB	PIGSTY 0.1.3 d12.aarch64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.3 · 709.8KiB	PIGSTY 0.1.3 d12.aarch64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.3 · 709.9KiB
d13.x86_64	PIGSTY 0.1.3 d13.x86_64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1.3 · 903.6KiB	PIGSTY 0.1.3 d13.x86_64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1.3 · 903.5KiB	PIGSTY 0.1.3 d13.x86_64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1.3 · 904.5KiB	PIGSTY 0.1.3 d13.x86_64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1.3 · 903.8KiB	PIGSTY 0.1.3 d13.x86_64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1.3 · 903.8KiB
d13.aarch64	PIGSTY 0.1.3 d13.aarch64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1.3 · 709.1KiB	PIGSTY 0.1.3 d13.aarch64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1.3 · 710.1KiB	PIGSTY 0.1.3 d13.aarch64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1.3 · 710.1KiB	PIGSTY 0.1.3 d13.aarch64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1.3 · 709.7KiB	PIGSTY 0.1.3 d13.aarch64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1.3 · 709.5KiB
u22.x86_64	PIGSTY 0.1.3 u22.x86_64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1.3 · 1014.7KiB	PIGSTY 0.1.3 u22.x86_64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1.3 · 1011.1KiB	PIGSTY 0.1.3 u22.x86_64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1.3 · 1011.2KiB	PIGSTY 0.1.3 u22.x86_64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1.3 · 1015.3KiB	PIGSTY 0.1.3 u22.x86_64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1.3 · 1014.3KiB
u22.aarch64	PIGSTY 0.1.3 u22.aarch64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1.3 · 847.6KiB	PIGSTY 0.1.3 u22.aarch64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1.3 · 847.4KiB	PIGSTY 0.1.3 u22.aarch64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1.3 · 847.5KiB	PIGSTY 0.1.3 u22.aarch64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1.3 · 847.7KiB	PIGSTY 0.1.3 u22.aarch64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1.3 · 847.6KiB
u24.x86_64	PIGSTY 0.1.3 u24.x86_64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-1PIGSTY~noble_amd64.deb PIGSTY · 0.1.3 · 1013.0KiB	PIGSTY 0.1.3 u24.x86_64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-1PIGSTY~noble_amd64.deb PIGSTY · 0.1.3 · 1012.6KiB	PIGSTY 0.1.3 u24.x86_64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-1PIGSTY~noble_amd64.deb PIGSTY · 0.1.3 · 1012.8KiB	PIGSTY 0.1.3 u24.x86_64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-1PIGSTY~noble_amd64.deb PIGSTY · 0.1.3 · 1012.3KiB	PIGSTY 0.1.3 u24.x86_64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-1PIGSTY~noble_amd64.deb PIGSTY · 0.1.3 · 1009.6KiB
u24.aarch64	PIGSTY 0.1.3 u24.aarch64.pg18 : postgresql-18-pg-render postgresql-18-pg-render_0.1.3-1PIGSTY~noble_arm64.deb PIGSTY · 0.1.3 · 841.3KiB	PIGSTY 0.1.3 u24.aarch64.pg17 : postgresql-17-pg-render postgresql-17-pg-render_0.1.3-1PIGSTY~noble_arm64.deb PIGSTY · 0.1.3 · 839.6KiB	PIGSTY 0.1.3 u24.aarch64.pg16 : postgresql-16-pg-render postgresql-16-pg-render_0.1.3-1PIGSTY~noble_arm64.deb PIGSTY · 0.1.3 · 839.5KiB	PIGSTY 0.1.3 u24.aarch64.pg15 : postgresql-15-pg-render postgresql-15-pg-render_0.1.3-1PIGSTY~noble_arm64.deb PIGSTY · 0.1.3 · 841.4KiB	PIGSTY 0.1.3 u24.aarch64.pg14 : postgresql-14-pg-render postgresql-14-pg-render_0.1.3-1PIGSTY~noble_arm64.deb PIGSTY · 0.1.3 · 841.6KiB
u26.x86_64	PIGSTY MISS	PIGSTY MISS	PIGSTY MISS	PIGSTY MISS	PIGSTY MISS
u26.aarch64	PIGSTY MISS	PIGSTY MISS	PIGSTY MISS	PIGSTY MISS	PIGSTY MISS

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:

pig install pg_render;          # Install for current active PG version

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

Feedback

Was this page helpful?

Thanks for the feedback! Please let us know how we can improve.

Sorry to hear that. Please let us know how we can improve.

Last Modified 2026-04-30: ext: update generated extension pages (b06020c)