From 3f44e3db72ad4097aae078c075a9b3cb3d6b761b Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 28 Mar 2018 08:32:43 -0400 Subject: Transforms for jsonb to PL/Python Add a new contrib module jsonb_plpython that provide a transform between jsonb and PL/Python. jsonb values are converted to appropriate Python types such as dicts and lists, and vice versa. Author: Anthony Bykov Reviewed-by: Aleksander Alekseev Reviewed-by: Nikita Glukhov --- doc/src/sgml/json.sgml | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml index 731b4696139..1df949e304a 100644 --- a/doc/src/sgml/json.sgml +++ b/doc/src/sgml/json.sgml @@ -569,4 +569,19 @@ SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @> '{"tags": ["qu compared using the default database collation. + + + Transforms + + + Additional extensions are available that implement transforms for the + jsonb type for the language PL/Python. The extensions for + PL/Python are called jsonb_plpythonu, + jsonb_plpython2u, and + jsonb_plpython3u (see for the PL/Python naming convention). If you + use them, jsonb values are mapped to Python dictionaries, + lists, and scalars, as appropriate. + + -- cgit v1.2.3