Decomposing jsonb field
You need to unnest the array then extract the keys as columns from the resulting JSON values:

select td.id, td.name, tg.tag_data -&gt;&gt; 'name' as tag_name, tg.tag_data -&gt;&gt; 'scope' as scope
from todos td
  cross join lateral jsonb_array_elements(td.tags) as tg(tag_data)
order by td.id;


Online example: http://rextester.com/DWYIJ81620