func.array_to_json
Returns the array as JSON. A PostgreSQL multidimensional array becomes a JSON array of arrays.
Returns the array as JSON. A PostgreSQL multidimensional array becomes a JSON array of arrays.
Expands a JSON array to a set of JSON elements.
Expands the outermost JSON object into a set of key/value pairs
Expands the outermost JSON object into a set of key/value pairs. The returned value will be of type text.
Returns JSON object pointed to by path elements. The return value will be a type of JSON.
Returns JSON object pointed to by path elements. The return value will be a type of text.
Returns set of keys in the JSON object. Only the "outer" object will be displayed.