[postgis-users] Postgis extension

[Simon Greener]

Can you force the creation of a record in geometry_colums?

⁣Get BlueMail for Android ​

On 1 Jul 2020, 09:24, at 09:24, imran hussain <imranhcet at hotmail.com> wrote:
>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
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>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/20200701/7400f687/attachment.html>