[postgis-users] Postgis extension

[imran hussain]

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-bounces at lists.osgeo.org> on behalf of Simon Greener <simon at spatialdbadvisor.com>
Sent: Tuesday, June 30, 2020 4:46:40 PM
To: PostGIS Users Discussion <postgis-users at 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 <lr at pcorp.us<mailto:lr at 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-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

________________________________

postgis-users mailing list
postgis-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200630/b863100e/attachment.html>