java - json array convert to object list. GitHub Gist: instantly share code, notes, and snippets. ... <看更多>
Replace 'json' with 'jsonb' for jsonb in all following SQL code. SELECT t.tbl_id, d.list FROM tbl t CROSS JOIN LATERAL ( SELECT string_agg(d.elem::text, ... ... <看更多>