PostgreSQL query cheat sheet

-- content: "[ { "id": "1"} ...]"
select (content::jsonb ->> 0)::jsonb -> 'id' as content_id
from test