Have you asked Alteryx about that. The psqlodbc driver has no knowledge of geometry_columns so I don't think this is an ODBC issue. It would be something in there use in their queries causing the failure.
Like for example if they are using GDAL (which underneath does use PSQLODBC) it looks for geometry_columns table, but you can turn this off with an environment variable. https://gdal.org/drivers/vector/pg.html#vector-pg In GDAL LIST_ALL_TABLES=YES A lot of third-party tools do use GDAL for spatial support so could be that. But I wouldn't have a clue where you'd set that in their use if that were the case. From: postgis-users [mailto:[email protected]] On Behalf Of imran hussain Sent: Tuesday, June 30, 2020 7:24 PM To: PostGIS Users Discussion <[email protected]> Subject: Re: [postgis-users] Postgis extension I am trying to connect from Alteryx using psqlodbc driver. The geometry_columns table is not populated for the table I am trying to access, since it's got no spatial data. _____ From: postgis-users <[email protected] <mailto:[email protected]> > on behalf of Simon Greener <[email protected] <mailto:[email protected]> > Sent: Tuesday, June 30, 2020 4:46:40 PM To: PostGIS Users Discussion <[email protected] <mailto:[email protected]> > Subject: Re: [postgis-users] Postgis extension Is geometry_columns fully populated? Get BlueMail for Android <http://www.bluemail.me/r?b=15860> On 1 Jul 2020, at 07:19, Regina Obe <[email protected] <mailto:[email protected]> > wrote: Which system are you connecting from? Sounds like whatever system you are using is designed to work with spatial tables. Like as I recall I think ArcMap uses PostgreSQL ODBC driver. There isn't any reason otherwise why you should be having issue connecting to a non-spatial table. I connect via SQL Server and MS Access all the time even when I have spatial tables in my database. There isn't even any reason why a system would check geometry_columns unless it's designed to work with spatial data. Hope that helps, Regina From: postgis-users [mailto:[email protected]] On Behalf Of imran hussain Sent: Tuesday, June 30, 2020 3:47 PM To: 'PostGIS Users Discussion' <[email protected] <mailto:[email protected]> > Subject: [postgis-users] Postgis extension Hi, I am trying to access the Postgres DB using ODBC driver. I have Postgis extension installed on my DB and when trying to query the non-spatial tables from the tool, I keep getting the error "no records returned from GEOMETRY_COLUMNS for this table". Is there any environment variable that would let the ODBC know that its a non spatial table and avoid looking into GEOMETRY_COLUMNS view ? Thanks, Imran Hussain _____ postgis-users mailing list [email protected] <mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
