Behaves like json_object, but as an aggregate function, so it only takes one key_expression and one value_expression parameter.
Signatures & examples
json_objectagg ( [ { key_expression { VALUE | ':' } value_expression } ] [ { NULL | ABSENT } ON NULL ] [ { WITH | WITHOUT } UNIQUE [ KEYS ] ] [ RETURNING data_type [ FORMAT JSON [ ENCODING UTF8 ] ] ])Behaves like json_object, but as an aggregate function, so it only takes one key_expression and one value_expression parameter.SELECT json_objectagg(k:v) FROM (VALUES ('a'::text,current_date),('b',current_date + 1)) AS t(k,v) → { "a" : "2022-05-10", "b" : "2022-05-11" }
Version history 1
- PG 15 → 16added
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source