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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
