jsonb

First statement returns two rows, one for each array. select jsonb_array_elements(msg->’root’) as el from js Then returns each individual values as text. with aa as ( select jsonb_array_elements(msg->’root’) as el from js ) select jsonb_array_elements(el)->>’cid’ as cid, jsonb_array_elements(el)->>’Display’ as Display, jsonb_array_elements(el)->>’FName’ as FName, jsonb_array_elements(el)->>’LName’ as LName from aa; This returns 3rd element of 2nd array … Read more