[postgis-users] Postgis extension

[Regina Obe]

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-bounces at lists.osgeo.org] On Behalf
Of imran hussain
Sent: Tuesday, June 30, 2020 3:47 PM
To: 'PostGIS Users Discussion' <postgis-users at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200630/e5a82f20/attachment.html>