FunctionsJSON

json_object_field

Returns the value associated with a key in a JSON object.

json_object_field(…) → JSON

Kind · scalar

Returns the value associated with a key in a JSON object.

Part of the JSON family.

json_object_agg_unique_strict

Builds a JSON object with unique keys and rejects NULL keys, NULL values, and duplicate-key collisions.

json_object_field_text

Returns the value associated with a key in a JSON object. The _text variant returns the field as text.