[postgis-users] How to export a table including polygon & multipolgon typed geometries to a shapefile

[Paul Ramsey]

create table dumptable as select thegeomyouwant,column,column2 from 
theoldtable;

then dump the dumptable.
P


Hisaji Ono wrote:
> Hello.
> 
>  After GeomUnioning  multipolygons by grouping a given field, both polygon &
> multipolgon typed geometries were generated in new table.
> 
>  I tried to execute pgsql2shp to generate a shapefile.
> 
>  However   pgsql2shp said following error message.
> 
> ERROR: Cannot have multiple geometry types in a shapefile.
> Use option -t(unimplemented currently,sorry...) to specify what type of
> geometry you want dumped
> 
>  Could you tell me this resolution?
> 
>  Regards.
> 
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_