happysundar
8/22/2014 - 11:34 PM

how to extract an array out of JSONB in postgres

how to extract an array out of JSONB in postgres

JSONB to array
content_copyfile_download
select array_agg(value) from jsonb_each_text('{"3d": "2011-05-20", "wide": "2011-05-20", "imax_3d": "2011-05-20"}'::jsonb);