How do I efficiently test for the existence of an array?


#1

I just want a true or false as to whether the array exists


#2

There’s an query language meta-data facility that lets you get a list of the arrays that exist.

SELECT COUNT(*) FROM list('arrays') WHERE name = 'your-array-name-here';

If that returns “0”, then the array doesn’t exist. If it returns “1”, then the array exists. If it returns any other number, please let us know.