func.array_to_json
Returns the array as JSON. A PostgreSQL multidimensional array becomes a JSON array of arrays.
JSON
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 December 20, 2022 at 10:05 AM EST: remove sitemap priority (56709da)