Is geometry_columns fully populated?
Get BlueMail for Android On 1 Jul 2020, 07:19, at 07:19, Regina Obe <[email protected]> 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:[email protected]] On >Behalf >Of imran hussain >Sent: Tuesday, June 30, 2020 3:47 PM >To: 'PostGIS Users Discussion' <[email protected]> >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 >[email protected] >https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
