Welcome to the community!
The equivalent of single-dimension type in AppSheet is List (virtual columns only), Enum and EnumList. Multi-dimension arrays cannot be used in an AppSheet column. I'd also say that AppSheet works well with a pure relational database, not object-relational database where extra object-related functionalities would be omitted.
To have your array column successfully imported in AppSheet, you can change its type temporarily to an acceptable type (e.g text) then once imported do the appropriate type changes.
If your column is a multi-dimensional array, while there's no equivalent column type in AppSheet, you can still however change your data structure to have the exact behaviour you would achieve with an array column. Instead of let's say a two-dimension array, you can have the extra dimension represented in a separate table and establish relevant table references, or if it is just the matter of one set of data, then you can just add a new column in the same table. The values will be easily retrievable with AppSheet's dereferencing expressions.
Actually, there's nothing that you can do with Postgre that you cannot achieve and more with AppSheet, you'll just have to organize your data accordingly. I hope this helps.
LinkedIn
Twitter
