hstore_plpython3u

transform between hstore 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	`hstore` `plpython3u` `hstore_pllua` `hstore_plluau` `hstore_plperl` `hstore_plperlu` `faker` `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 hstore_plpython3u;

Usage

hstore_plpython3u: Transform between hstore and PL/Python3

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

CREATE EXTENSION hstore_plpython3u;

CREATE FUNCTION hstore_to_pairs(val hstore) RETURNS text
LANGUAGE plpython3u TRANSFORM FOR TYPE hstore AS $$
  # val is now a Python dict
  return ', '.join(f'{k}={v}' for k, v in sorted(val.items()))
$$;

CREATE FUNCTION make_hstore(key text, value text) RETURNS hstore
LANGUAGE plpython3u TRANSFORM FOR TYPE hstore AS $$
  return {key: value}
$$;

SELECT hstore_to_pairs('a=>1, b=>2'::hstore);
SELECT make_hstore('color', 'blue');

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)