[postgis-users] Postgis extension

imran hussain imranhcet at hotmail.com
Tue Jun 30 16:23:44 PDT 2020

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,


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


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 ?


Imran Hussain


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

More information about the postgis-users mailing list