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

Question

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 · Answer

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.

Robin_McIntosh · Answer

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-ODBC-Connection/td-p/660646

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/NO-COLUMNS-Returned-PostgreSQL-ODBC-Connection/td-p/763702

bbehjoo · Answer

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