FunctionsJSON

json_object_field_text

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

json_object_field_text(…) → String

Kind · scalar

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

Part of the JSON family.

json_object_field

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

json_object_keys

Returns the keys of a JSON object. In set-returning contexts this produces one row per key; otherwise it may return an array of keys.