FUNCTIONS / JSON FUNCTIONS AND OPERATORS

jsonb_each_text

Expands the top-level JSON object into a set of key/value pairs.

Signatures & examples

jsonb_each_text ( jsonb ) → setof record ( key text, value text )

Expands the top-level JSON object into a set of key/value pairs. The returned values will be of type text.

select * from json_each_text('{"a":"foo", "b":"bar"}') →  key | value
-----+-------
 a   | foo
 b   | bar

Version history 2

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source