JSON_TYPEOF ​

Prerequisite: To use this function, enable the enable_full_json configuration parameter. For more details, refer to JSON Functions.

Returns the type of the outermost JSON element as a VARCHAR string. Possible types are object, array, string, number, boolean, and null.

JSON_TYPEOF(jsonb_expression)

jsonb_expression

The JSON/JSONB value to inspect.

Examples ​

select json_typeof('{"ticker": "INTC"}');
-- object

select json_typeof('{"ticker": "INTC"}':$.ticker);
-- string

select json_typeof('{"ticker": "INTC"}':$.price null on error);
-- <null>