FunctionsJSON

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.

json_object_keys(…) → JSON

Kind · scalar

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.

Part of the JSON family.

json_object_field_text

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

json_path_exists

Evaluates a SQL/JSON path expression against a JSON document. Returns true if the path matches at least one item in the document.