[postgis-users] shp2pgsql question

[Markus Schaber]

Hi, Stephen,

Stephen Davies wrote:

> My generated SQL does not have MULTIPOLYGON "wrappers". It looks like 
> this:
> 
> INSERT INTO "unit" (probe_id,geom) VALUES 
> (0,'SRID=4283;010600000001000000010300000001000000090000005F420577B9981141E42057CB33575741DDBD92AADD9711410971407D60575741828DEB272E981141E65C0A3B62575741CF0C871A2F9911419CF8EA4637575741582B2482BD991141EFA42ABB2F575741C284762BD89B11410C46DBCC215757410641ECE1CE9B114189DB57B41E5757415DE564251099114107712FD42C5757415F420577B9981141E42057CB33575741');
> 
> Am I missing something?

Thats the binary format, for the text format use the -w option. However,
using the text format may break your data, due to rounding errors with
broken floating point parsers on various platforms.

HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org