Categories: Semistructured Data

MAP_KEYS

Returns all keys from a map expression.

Syntax

MAP_KEYS(input map) → array of strings

• input: A map expression for which to return an array of keys.

Examples

SELECT MAP_KEYS(properties)
-- ['Cover', 'Publication Year', 'Color']