On Thu, Jun 28, 2018 at 1:40 PM, Moritz Lennert < [email protected]> wrote: > > On 28/06/18 09:59, Paul Shapley wrote: >> >> Hi, >> >> I am trying to export a vector map to PostGIS. Has anyone come across the 'Unable to describe table' error? I suspect my config could be wrong. >> >> v.out.postgis --overwrite input=APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vct@PERMANENT output=PG:dbname=webgis output_layer=APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vct options=FID=cat, GEOMETRY_NAME=wkb_geometry, SPATIAL_INDEX=YES, PRIMARY_KEY=YES >> DBMI-PostgreSQL driver error: >> select * from grass_gis.APGB_aerial_2_i_segment_drained_peat >> _with_exposed_haggs_vct where 1 = 0 >> ERROR: relation "grass_gis.apgb_aerial_2_i_segment_drained_ >> peat_with_exposed_haggs_vct" does not exist >> LINE 1: select * from >> grass_gis.APGB_aerial_2_i_segment_drained_peat... >> ^ >> DBMI-PostgreSQL driver error: >> select * from grass_gis.APGB_aerial_2_i_segment_drained_peat >> _with_exposed_haggs_vct where 1 = 0 >> ERROR: relation "grass_gis.apgb_aerial_2_i_segment_drained_ >> peat_with_exposed_haggs_vct" does not exist >> LINE 1: select * from >> grass_gis.APGB_aerial_2_i_segment_drained_peat... >> ^ >> *ERROR: Unable to describe table* <grass_gis.APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vct> > > > It looks like it is trying to read the input attrubute table from postgresql (schema grass_gis). Do you use PostgreSQL as attribute table backend ? Could you provide the output of db.connect -p in that mapset ?
ore precise would be v.db.connect -p APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vct@PERMANENT because there may be a bug in v.out.postgis, not properly reading the database connection of the input vector. Markus Metz > > Moritz > > _______________________________________________ > grass-user mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/grass-user
_______________________________________________ grass-user mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/grass-user
