[postgis-users] Postgis extension

[Simon Greener]

Is geometry_columns fully populated?



⁣Get BlueMail for Android ​

On 1 Jul 2020, 07:19, at 07:19, Regina Obe <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/20200701/20473e87/attachment.html>