[postgis-users] Shp2Pgsql - how to handle carriage returns ?
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.
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?
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
t: +44 870 608 0063
More information about the postgis-users