FunctionsJSON

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(…) → JSON

Kind · scalar

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.

Part of the JSON family.

json_merge_patch

Applies a JSON Merge Patch (RFC 7396) document to a target JSON value and returns the patched result. Use this for partial updates of JSON objects.

json_object_agg

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