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 <[email protected]> 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 <[email protected]> on behalf >of Simon Greener <[email protected]> >Sent: Tuesday, June 30, 2020 4:46:40 PM >To: PostGIS Users Discussion <[email protected]> >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 <[email protected]<mailto:[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
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
