[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