jsonb_plpython3u

transform between jsonb and plpython3u

https://www.postgresql.org/docs/current/plpython.html

Overview

Package	Version	Category	License	Language
`plpython3u`	`1.0`	LANG	PostgreSQL	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
3290	`plpython3u`	No	Yes	No	Yes	No	No	`pg_catalog`
3291	`jsonb_plpython3u`	No	No	No	Yes	No	Yes	-
3292	`ltree_plpython3u`	No	Yes	No	Yes	No	Yes	-
3293	`hstore_plpython3u`	No	No	No	Yes	No	Yes	-

Related	`plpython3u` `faker` `jsonb_plperl` `jsonb_plperlu` `pg_jsonschema` `jsquery` `plpgsql`

Version

PG18	PG17	PG16	PG15	PG14
1.0	1.0	1.0	1.0	1.0

Install

Note: This is a built-in contrib extension of PostgreSQL

CREATE EXTENSION jsonb_plpython3u;

Usage

jsonb_plpython3u: Transform between jsonb and PL/Python3

Provides a transform for the jsonb type for PL/Python3U. When loaded, jsonb values are automatically converted to Python dicts, lists, and scalars, and vice versa.

CREATE EXTENSION jsonb_plpython3u;

CREATE FUNCTION jsonb_keys_sorted(val jsonb) RETURNS text[]
LANGUAGE plpython3u TRANSFORM FOR TYPE jsonb AS $$
  # val is now a Python dict
  return sorted(val.keys())
$$;

CREATE FUNCTION build_jsonb(name text, age integer) RETURNS jsonb
LANGUAGE plpython3u TRANSFORM FOR TYPE jsonb AS $$
  return {"name": name, "age": age}
$$;

SELECT jsonb_keys_sorted('{"b": 2, "a": 1, "c": 3}'::jsonb);
SELECT build_jsonb('Alice', 30);

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-03-12: add pg extension catalog (95749bf)