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_plperl` `hstore_plperlu` `hstore`

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

hstore_plpython3u

Overview

Version

Install

Usage

Was this page helpful?