[postgis-users] shp2pgsql bug?

[Mark Cave-Ayland]

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