Get all keys in a Json object

prateek · March 30, 2021, 5:20am

Hi

Do we have a method to get all the keys in a json object in memsql? Similar to JSON_KEYS of MySQL or json_object_keys of PostgreSQL. Couldn’t find one in the MemSQL docs.

Thanks & Regards.

hanson · March 30, 2021, 8:36pm

Hi @prateek. Welcome to the SingleStore forum! We don’t have JSON_KEYS now but we’re definitely considering it for a future release.

oak · January 21, 2022, 10:32pm

SS 7.6 released this JSON_KEYS · SingleStore Documentation