PostgreSQL connection "typname = 'geometry'": No Columns Returned

[bbehjoo]

Trying to set up a connection to PostgresSQL, able to get into to the database and see all the tables and fields but as soon as I try to run the table I get this error message: 

Input Data (3) Error opening "SELECT oid from pg_type where typname = 'geometry'": No Columns Returned.

Tried a few different versions of the PostgreSQL drivers with no luck. Also tried the Simba driver from the Alteryx downloads but can't even get a successful connection on that one in ODBC admin. Keep getting the below failed message when trying to. 

Any help would be appreciated. 

[bbehjoo]

Still looking to solve this is anybody could help it would be greatly appreciated. 

[Robin_McIntosh]

Here are a couple of other posts aboput the same issue.  Have you seen these?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/No-Columns-Returned-with-PostgreSQL-OD...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/NO-COLUMNS-Returned-PostgreSQL-ODBC-Co...

[bbehjoo]

I did and unfortunately they did not provide a solution. I have tried both unicode and ansi driver and I am able to see all the columns. The issue comes when I actually try to run the workflow.