[Qgis-user] Displaying the command of Database Shapefile Loader

[Etienne Tourigny]

If you are referring to the DB Manager plugin, it uses the QGIS API to
import shapefiles, not the external tool shp2pgsql.

Etienne


On Fri, Apr 18, 2014 at 11:26 AM, Gunnar Oehmichen
<oehm8895 at uni-landau.de>wrote:

> Hello There,
>
> Using QGIS 2.2 on Ubuntu 12.04.
>
> I uploaded a shapefile to a remote postgis-database using the
> DatabaseManger -> Import Shapefile.
>
> Is it possible to display the shp2pgsql command qgis used to load a
> shapefile to a postgisdatabase (I guess QGIS is just using the tool). I
> would like to compare this command to what Ive entered manually into the
> terminal, producing the following error (Probably not belonging here):
>
> I tried to do a shp2pgsql command:
>
> shp2pgsql -i shapefile.shp schema.test | psql -h localhost -d 'DB' -U
> oehmichen
> Shapefile type: Polygon
> Postgis type: MULTIPOLYGON[2]
> Password for user USER:
> SET
> SET
> BEGIN
> NOTICE:  CREATE TABLE will create implicit sequence "test_gid_seq" for
> serial column "test.gid"
> CREATE TABLE
> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "test_pkey" for table "test"
> ALTER TABLE
>                  addgeometrycolumn
> ---------------------------------------------------
>  planee.test.geom SRID:0 TYPE:MULTIPOLYGON DIMS:2
> (1 row)
>
> ERROR:  invalid input syntax for type numeric: "7313000,000000000000000"
> LINE 1: ...56Z','Basis-DLM','urn:adv:oid:9110','301IRDC_006','7313000,0...
>
> Thanks for your help,
>
> Gunnar
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20140418/0e6235a8/attachment.html>