FunctionsJSON

json_extract_path_text

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

json_extract_path_text(…) → String

Kind · scalar

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

Part of the JSON family.

json_extract_path

Extracts a nested JSON value using variadic path segments (keys or indexes).

json_extract_raw

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