Hi Markus, OK here is the result of v.db.connect -p
v.db.connect -p APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vector Vector map <APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vector> is connected by: layer <1/grass_gis.APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vector> table <grass_gis.APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs_vector> in database <webgis> through driver <pg> with key <cat> I recall some years ago you had to delete the 'db.login' file and recreate it but this would lose the connection to the vector layer attribute table (sqlite.db). Thanks, Paul Shapley On 28 June 2018 at 13:22, Markus Metz <markus.metz.gisw...@gmail.com> wrote: > > > On Thu, Jun 28, 2018 at 1:40 PM, Moritz Lennert < > mlenn...@club.worldonline.be> 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 > > grass-user@lists.osgeo.org > > https://lists.osgeo.org/mailman/listinfo/grass-user > > -- *Paul J. Shapley *MSc CGeog (GIS) FRGS
_______________________________________________ grass-user mailing list grass-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-user
