# PostgreSQL column type supported by Trino

**URL:** <https://www.starburst.io/community/forum/t/postgresql-column-type-supported-by-trino/222>\
**Category:** Trino\
**Tags:** postgresql\
**Created:** [November 1, 2022, 4:50pm UTC](https://www.starburst.io/community/forum/t/postgresql-column-type-supported-by-trino/222 "2022-11-01T16:50:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alex](https://www.starburst.io/community/forum/letter_avatar_proxy/v4/letter/a/db5fbb/32.png) [@Alex](https://www.starburst.io/community/forum/u/Alex)\
**Post date:** [November 1, 2022, 4:50pm UTC](https://www.starburst.io/community/forum/t/postgresql-column-type-supported-by-trino/222/1 "2022-11-01T16:50:51Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Alex](https://www.starburst.io/community/forum/letter_avatar_proxy/v4/letter/a/db5fbb/32.png) [@Alex](https://www.starburst.io/community/forum/u/Alex)\
**Post date:** [November 2, 2022, 4:57pm UTC](https://www.starburst.io/community/forum/t/postgresql-column-type-supported-by-trino/222/2 "2022-11-02T16:57:44Z")

</div>

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