JSON Scalar

json_extract_string()

Arguments & returns

6 overloads

Scalar

Overload link	`col0`	`col1`	Returns
#01	`JSON`	`BIGINT`	`VARCHAR`
#02	`JSON`	`VARCHAR`	`VARCHAR`
#03	`JSON`	`VARCHAR[]`	`VARCHAR[]`
#04	`VARCHAR`	`BIGINT`	`VARCHAR`
#05	`VARCHAR`	`VARCHAR`	`VARCHAR`
#06	`VARCHAR`	`VARCHAR[]`	`VARCHAR[]`

Extract a JSON field directly as text, ready to use in the rest of your query.

SELECT json_extract_string(
  '{"farm":"Willow Creek","crops":["apples","pears"]}',
  '$.farm'
) AS farm;

Haybarn WASM 1.5.6-rc6 · In your browser

Guide recipe · Run to view results.