[GRASS-user] v.out.postgis

Markus Neteler neteler at osgeo.org
Thu Jun 28 04:29:49 PDT 2018


Hi

Paul Shapley <p.shapley at gmail.com> schrieb am Do., 28. Juni 2018, 09:59:

> 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 at 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
>


... upon quick inspection:
the where 1 = 0 above looks strange to me.

But I don't know what it could originate from.

Markus


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>
>
>
> Thanks,
> *Paul J. Shapley*
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/grass-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20180628/dd88ba5a/attachment-0001.html>


More information about the grass-user mailing list