AW: [postgis-users] shp2pgsql question

[Uwe Seher]

Hello!
You can replace the strings like described, if you are sure that there are
no Multipolygons. If there are some, you can try to get the single
geometries with Regular Expressions and rebuild the polygons as you like.
But i think, it is easier to crack them with PostGIS-functions.

Cheers

Uwe Seher 


> -----Ursprüngliche Nachricht-----
> Von: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] Im 
> Auftrag von Stephen Davies
> Gesendet: Mittwoch, 4. Oktober 2006 09:51
> An: postgis-users at postgis.refractions.net
> Betreff: [postgis-users] shp2pgsql question
> 
> I need to load data from a shape file into a PostGIS database.
> shp2pgsql almost does this for me but the geometry type generated is
> MULTIPOLYGON(2) instead of POLYGON as required by the table 
> constraint.
> 
> Is there a way to edit the generated SQL to tell PostGIS to 
> convert from one to the other? (I would prefer to not have to 
> use a temporary table).
> 
> Cheers and thanks,
> Stephen Davies
> --
> ==============================================================
> ==========
> This email is for the person(s) identified above, and is 
> confidential to the sender and the person(s).  No one else is 
> authorised to use or disseminate this email or its contents.
> 
> Stephen Davies Consulting                            Voice: 
> 08-8177 1595
> Adelaide, South Australia.                             Fax: 
> 08-8177 0133
> Computing & Network solutions.                       
> Mobile:0403 0405 83
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


____________
Virus checked by G DATA AntiVirusKit