By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
| id | jsonb_pretty |
|---|---|
| 1 | { "key1": "value1", "key2": [ { "key3": "value3" }, { "key3": "value4" } ] } |
| 2 | { "key2": [ { "key4": { "key3": "value6" } } ], "key3": "value5" } |
INSERT 0 2
| jsonb_path_query |
|---|
| "value3" |
| "value4" |
| "value5" |
| "value6" |
SELECT 4