Functions / Aggregate Functions

json_object_agg

Collects all the key/value pairs into a JSON object.

Reading PG 18current·documented in 14 of 27 versions, 9.4 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

json_object_agg ( key "any", value "any" ORDER BY input_sort_columns ) → json

Collects all the key/value pairs into a JSON object. Key arguments are coerced to text; value arguments are converted as per to_json or to_jsonb. Values can be null, but keys cannot.

Version history 4

16 → 17 changed
15 → 16 changed
12 → 13 changed
9.3 → 9.4 added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source