Postgres Array data types

Hi,

I connected to a postgres database that contains array data types like VARCHAR[]. However, these columns show up with UNKNOWN as data type. Can anybody help?

Thanks, inkihh

These array types are not supported natively in HeidiSQL. They will however show up with that UNKNOWN type, and you should be able to edit them, or probably not in a way you need it.

So what does this effectively mean? I can't use Heidisql with Postgres databases that contain array types?

You will have to decide yourself whether you can work around these limitations.