Functions / Aggregate Functions

json_object_agg_strict

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

Reading PG 18current·documented in 5 of 27 versions, 16 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_strict ( key "any", value "any" ) → 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. The key can not be null. If the value is null then the entry is skipped,

Version history 2

18 → 19 changed
15 → 16 added

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