PostgreSQL column type supported by Trino

Trino
1

Hi

I am using the postgresql connector to a Postgres database, and while querying a table with Trino I realized 2 columns of that table are not read by Trino. These two columns contain list of strings, the Postgres type is : character varying(32)
Using the Trino CLI and the command “SHOW COLUMNS FROM mytable;”
I don’t see the columns listed.
My version of Trino is 401 and my Postgres server version is 12.2. Is this type not supported
by Trino ? Is there a way to access these columns or is there no other choice but to transform
the Postgres table to store these columns with a different type ?

Thanks,

Alex

2

Ok sorry I found the answer in the Trino documentation, I just had to change the value of postgresql.array-mapping.