[postgis-users] Shp2Pgsql - how to handle carriage returns ?

Ivan Mincik ivan.mincik at gmail.com
Fri Apr 3 06:21:15 PDT 2009


On Friday 03 April 2009, Stefan Schwarzer wrote:
> Hi there,
> 
> I have a shapefile I would like to import into my database, but the  
> shp2pgsql seems to have problems with carriage returns in the DBF:
> 
> 	ERROR:  literal carriage return found in data
> 	HINT:  Use "\r" to represent carriage return.
> 
> What can I do about it? I don't see any solution, other than deleting  
> the column where this occurs. But that's not very cool...
> 
> Thanks for any hints,
> 
> Stef
Try to do not use dump format ( don't use parameter -D).  shp2pgsql will use simple INSERT INTO command. It will take longer time to import, but it can solve your problem.
Ivan
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 





More information about the postgis-users mailing list