FunctionsJSON

json_extract_raw

Extracts a JSON fragment and returns the raw JSON token without scalar coercion.

json_extract_raw(…) → JSON

Kind · scalar

Extracts a JSON fragment and returns the raw JSON token without scalar coercion.

Part of the JSON family.

json_extract_path_text

Extracts a nested value via variadic path segments and returns it in textual form.

json_extract_string

Extracts the JSON value at the given path and returns it as a string. If the path is missing, the JSON is invalid, or the value is not a JSON string, the result is NULL.