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 <postgis-users-boun...@lists.osgeo.org> on behalf of Simon Greener <si...@spatialdbadvisor.com> Sent: Tuesday, June 30, 2020 4:46:40 PM To: PostGIS Users Discussion <postgis-users@lists.osgeo.org> 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 <l...@pcorp.us<mailto:l...@pcorp.us>> 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:postgis-users-boun...@lists.osgeo.org] On Behalf Of imran hussain Sent: Tuesday, June 30, 2020 3:47 PM To: 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org> 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 postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users