Functions / Json Functions And Operators

jsonb_each

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

Reading PG 18current·documented in 14 of 27 versions, 9.4 to 20

Signatures & examples

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

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

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

Version history 2

Definition snapshot: b7bd9cda · English manual source