Functions / Aggregate Functions

jsonb_object_agg

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

Reading PG 18current·documented in 13 of 27 versions, 9.5 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

jsonb_object_agg ( key "any", value "any" ORDER BY input_sort_columns ) → jsonb

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.4 → 9.5 added

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