JSON


func.array_to_json

Returns the array as JSON. A PostgreSQL multidimensional array becomes a JSON array of arrays.

func.json_array_elements

Expands a JSON array to a set of JSON elements.

func.json_each

Expands the outermost JSON object into a set of key/value pairs

func.json_each_text

Expands the outermost JSON object into a set of key/value pairs. The returned value will be of type text.

func.json_extract_path

Returns JSON object pointed to by path elements. The return value will be a type of JSON.

func.json_extract_path_text

Returns JSON object pointed to by path elements. The return value will be a type of text.

func.json_object_keys

Returns set of keys in the JSON object. Only the "outer" object will be displayed.

Last modified April 06, 2022 at 10:08 AM EST: Initial Documentation Commit (371ae8f)