json_agg ( anyelement ORDER BY input_sort_columns ) → jsonCollects 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
json_agg
Read PG 18 manual ↗Collects all the input values, including nulls, into a JSON array.
Signatures & examples
Version history 4
- PG 16 → 17changed
- PG 12 → 13changed
- PG 9.3 → 9.4changed
- PG 9.2 → 9.3added
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source