summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2018-03-28 08:32:43 -0400
committerPeter Eisentraut <peter_e@gmx.net>2018-03-28 08:37:18 -0400
commit3f44e3db72ad4097aae078c075a9b3cb3d6b761b (patch)
tree807ec18db75caef36a5a218fe778f53d03e698e0 /doc/src
parenta437551a228a5099c305d1376188d6926c043724 (diff)
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 <a.bykov@postgrespro.ru> Reviewed-by: Aleksander Alekseev <a.alekseev@postgrespro.ru> Reviewed-by: Nikita Glukhov <n.gluhov@postgrespro.ru>
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/json.sgml15
1 files changed, 15 insertions, 0 deletions
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-&gt;'guid', jdoc-&gt;'name' FROM api WHERE jdoc @&gt; '{"tags": ["qu
compared using the default database collation.
</para>
</sect2>
+
+ <sect2>
+ <title>Transforms</title>
+
+ <para>
+ Additional extensions are available that implement transforms for the
+ <type>jsonb</type> type for the language PL/Python. The extensions for
+ PL/Python are called <literal>jsonb_plpythonu</literal>,
+ <literal>jsonb_plpython2u</literal>, and
+ <literal>jsonb_plpython3u</literal> (see <xref
+ linkend="plpython-python23"/> for the PL/Python naming convention). If you
+ use them, <type>jsonb</type> values are mapped to Python dictionaries,
+ lists, and scalars, as appropriate.
+ </para>
+ </sect2>
</sect1>