[GRASS-dev] [GRASS GIS] #3836: GRASS: db.in.ogr fails where v.in.ogr succeeds

[GRASS GIS]

#3836: GRASS: db.in.ogr fails where v.in.ogr succeeds
--------------------+-------------------------
 Reporter:  Lads    |      Owner:  grass-dev@…
     Type:  defect  |     Status:  new
 Priority:  normal  |  Milestone:
Component:  Vector  |    Version:  unspecified
 Keywords:          |        CPU:  x86-64
 Platform:  Linux   |
--------------------+-------------------------
 This report refers to GRASS 7.6. To import a spatial table from PostGIS I
 use, successfully, the following formulation with v.in.ogr:


 {{{
 > v.in.ogr input="PG:host=pg-server dbname=dsm user=duque004
 password=secret" layer="observations.profiles" output=profiles -o
 Over-riding projection check
 Check if OGR layer <observations.profiles> contains polygons...
 ERROR 1: Could not fetch SRS:
  100%
 Creating attribute table for layer <observations.profiles>...
 Importing 141584 features (OGR layer <observations.profiles>)...
  100%
 -----------------------------------------------------
 Building topology for vector map <profiles at test>...
 Registering primitives...

 }}}

 But if I feed the same parameters to db.in.ogr, it fails to find the
 table:


 {{{
 > db.in.ogr input="PG:host=pg-server dbname=dsm user=duque004
 password=secret" db_table="observations.profiles" output=profiles
 ERROR: Unable to open data source <observations.profiles>
 ERROR: Input table <observations.profiles> not found or not
        readable
 }}}

 This bug report is related to the following discussions at StackExchange:

 [https://gis.stackexchange.com/q/316383/21532]

 [https://gis.stackexchange.com/q/316100/21532]

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/3836>
GRASS GIS <https://grass.osgeo.org>