create table foo (bar); insert into foo (bar) values ('{"answers": [42]}'); select jsonb_extract(bar, '$.answers') from foo; ;#42