JSON

JSON functions like func-json-each-text, func-json-estract-path, and func-json-object-keys

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 November 27, 2023 at 12:56 PM EST: Restructured the file structure/a few changes (f6c58b8)