On Wednesday 05 March 2008 16:54:02 Stephen Woodbridge wrote: > Hi all, > > I have run into a problem with shp2pgsql -D that uses the COPY command. > I have recently run into various files on different projects that seem > to have newlines embedded in some of the character data fields. This > totally breaks using the -D option. Similarly, an embedded tab char > would break this. > > I can load the data without the -D but it takes significantly longer. > > I am wondering if an option to replace newline and tab characters with a > space might not be a good option to have. > > -Steve
Hi Steve, Yes, you're probably right - COPY has slightly different escaping requirements according to the manual here: http://www.postgresql.org/docs/8.3/interactive/sql-copy.html. This would be a good first patch for someone interested in PostGIS, so feel free to have a go. If not, add an entry onto the wiki at http://postgis.refractions.net/support/wiki/index.php?IssuesPatchesPending and someone should pick it up in due course. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
