postgres query jsonb array code example Example: postgresql parse json array SELECT array_to_json(array_col) as array_col FROM t_name;