FunctionsJSON

json_object_agg

Builds a JSON object by grouping key/value pairs; when the same key repeats, the last value wins.

json_object_agg(…) → JSON

Kind · aggregate

Builds a JSON object by grouping key/value pairs; when the same key repeats, the last value wins.

Part of the JSON family.

json_object

Builds a JSON object from key/value arguments. Keys are interpreted as strings; values are converted to JSON using the engine's JSON mapping rules.

json_object_agg_strict

Builds a JSON object like json_object_agg but rejects NULL keys and NULL values.