postgres jsonb

jsonb_each.sql

-- {"1": [{"id": 1,"name": "Max"},{"id": 11,"name": "Perez"}],"2": [{"id": 2,"name": "Leclerc"},{"id": 3,"name": "Sainz"}]}

select 
j.*
from test,
jsonb_each(metadata) as j

     
select
 jsonb_each(metadata)
from test



with a as (
select 
key as k,
jsonb_array_elements(value) as v
from test,
jsonb_each(metadata) as j
)
select * from a
where v->>'name' = 'Max'