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

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Tue Apr 7 02:48:38 PDT 2009


Dave Fuhry wrote:

> I use the attached patch, which tweaks shp2pgsql to handle newlines
> (\n) and carriage returns (\r), replaces hi-bit characters with a
> question mark, and removes some geometry checks.
> 
> You probably only want to do the first of those three.  In that case,
> the patch should be easy to modify.  Hope you find it helpful.
> 
> -Dave

Hmmm this sounds like a shp2pgsql bug, since the escaping behaviours for 
COPY output and INSERT output should be different. Dave, could you add 
this to the bug tracker?


Many thanks,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063



More information about the postgis-users mailing list