clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 984303 fiddles created (11678 in the last week).

with gugu (data) as ( values ( '{ "key1": { "value1": "normal", "value2": [ "PogU" ] }, "key2": {"value1": "important", "value2": "bubu"} }'::jsonb) ) select d.val ->> 'value1' as value1, d.val ->> 'value2' as value2 from gugu cross join jsonb_each(data) as d(ky,val)
value1 value2
normal ["PogU"]
important bubu
 hidden batch(es)