Re: How to search a string inside a json structure

Hi,

select * from test;
 id |           main          
----+--------------------------
  1 | [{"A": "b"}, {"B": "b"}]
(1 row)

select * from test, jsonb_array_elements(test.main) as m, jsonb_each(value);
 id |           main           |   value    | key | value
----+--------------------------+------------+-----+-------
  1 | [{"A": "b"}, {"B": "b"}] | {"A": "b"} | A   | "b"
  1 | [{"A": "b"}, {"B": "b"}] | {"B": "b"} | B   | "b"
(2 rows)

Thanks