JSON Functions¶
JSON Format¶
JSON is a language-independent data format that represents data as
human-readable text. A JSON text can represent a number, a boolean, a
string, an array, an object, or a null, with slightly different grammar.
For instance, a JSON text representing a string must escape all characters
and enclose the string in double quotes, such as "123\n"
, whereas a JSON
text representing a number does not need to, such as 123
. A JSON text
representing an array must enclose the array elements in square brackets,
such as [1,2,3]
. More detailed grammar can be found in
this JSON introduction.
JSON Functions¶
- get_json_object(json, path) varchar ¶
Extracts a json object from path:
SELECT get_json_object('{"a":"b"}', '$.a'); -- b