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]> 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] https://lists.osgeo.org/mailman/listinfo/postgis-users
