[postgis-users] Re : Problem during Imoporting shapefile in postGIS !!

[erik tamno]

Hello
Thank you, I finally have the best result with shp2pgsql : 
I was inspire by this document : http://postgis.refractions.net/docs/ch04.html#RefObject 

 This is the better solution to spacify all the parameter :  windows cmd :
 
[#] c:\Program Files\PostgreSQL\8.4\bin>sh2pgsql -s 4326 -c -D -i -I d:\DATA\buildings.shp buildings_table | psql -d postgis -U postgres
 where > buildings-table is the name of my table
This will create the table with primary key and Index and this is what I want.. as you can see on attachment 

Thank you 

Erik





----- Message d'origine ----
De : Nicolas Ribot <nicolas.ribot at gmail.com>
À : PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Envoyé le : Mer 16 juin 2010, 9h 39min 58s
Objet : Re: [postgis-users] Problem during Imoporting shapefile in postGIS !!

> Hello
> I'm Trying to import Shapefile files from Alsace city in France inside PostGIS with OpenJUMP. I can view all layers in OpenJUMP . Alsace shapefiles are available here : http://download.geofabrik.de/osm/europe/france/
>
> but I got this error in attached
>
> Please help me ...
>
> Erik
>

Hi,

The 'name' attribute seems to generate a curious insert statement.
Could you check its values ? maybe an encoding issue ?

Did you try importing the shapefile with shp2pgsql ? The messages may
be more explicit.

Nicolas
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



      
-------------- next part --------------
A non-text attachment was scrubbed...
Name: shapefile loading.JPG
Type: image/pjpeg
Size: 95695 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100616/340198f2/attachment.bin>