[Geomoose-users] shp2pgsql error

John Kummun boache578 at yahoo.com
Thu Nov 13 10:54:34 EST 2008


How do i resolve this error when i am trying to convert from shapefile to pgsql
 

C:\Program Files\PostgreSQL\8.3\bin>Shp2pgsql.exe -I -D C:\ms4w\apps\GeoMOOSE\ma
ps_countydemo\other\Parcels.shp parcels | psql postgis postgres
Shapefile type: Polygon
Postgis type: MULTIPOLYGON[2]
BEGIN
NOTICE:  CREATE TABLE will create implicit sequence "parcels_gid_seq" for serial
 column "parcels.gid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parcels_pkey" fo
r table "parcels"
CREATE TABLE
                    addgeometrycolumn
----------------------------------------------------------
 public.parcels.the_geom SRID:-1 TYPE:MULTIPOLYGON DIMS:2
(1 row)
ERROR:  literal carriage return found in data
HINT:  Use "\r" to represent carriage return.
CONTEXT:  COPY parcels, line 24965
ERROR:  current transaction is aborted, commands ignored until end of transactio
n block
ROLLBACK
 
Can someone tells me what is going here?
 
Thanks
Bernard


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20081113/5639fdae/attachment.html


More information about the Geomoose-users mailing list