FunctionsJSON

json_build_object

Builds a JSON object from alternating key/value arguments, converting each value to JSON.

json_build_object(…) → JSON

Kind · scalar

Builds a JSON object from alternating key/value arguments, converting each value to JSON.

Part of the JSON family.

json_build_array

Constructs a JSON array from the function arguments for each row, preserving argument order.

json_concat

Concatenates two JSON values: objects are merged by key, arrays are concatenated, and mixed types are wrapped into arrays.