jsonb_agg ( anyelement ORDER BY input_sort_columns ) → jsonbCollects all the input values, including nulls, into a JSON array. Values are converted to JSON as per
to_json or to_jsonb.FUNCTIONS / AGGREGATE FUNCTIONS
jsonb_agg
Read PG 18 manual ↗Collects all the input values, including nulls, into a JSON array.
Signatures & examples
Version history 3
- PG 16 → 17changed
- PG 12 → 13changed
- PG 9.4 → 9.5added
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source