select query to fetch json column internal objects
You can use jsonb_array_elements() for that:

with sample_data (json_col) as (
  values ('{"disks":{"value":[{"Type":"NA"},{"Type":"NA"}]}}'::jsonb)
)
select x.t -&gt;&gt; 'Type' as type
from sample_data, jsonb_array_elements(json_col -&gt; 'disks' -&gt; 'value') as x(t);


returns

type
----
NA  
NA