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` `pgbson` `pgjq` `jsonb_plperl` `jsonb_plperlu` `jsquery` `pg_jsonschema` `jsonschema` `pg_projection`

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

jsonb_plpython3u

Overview

Version

Install

Usage

Was this page helpful?