[postgis-users] is there any 'common' geometry type?

[Nicolas Ribot]

On 14 April 2010 07:54, Li Li <fancyerii at gmail.com> wrote:
> thank you. Now I have many data with type POLYGON, how can I convert
> them to MULTIPOLYGON? I don't want my existed data missing. I tried to
> update the column from geometry_columns set its value to MULTIPOLYGON.
> But When I insert a MULTIPOLYGON,it failed.
>

Hi, st_mutli will change simple geometries into MULTI one

update mytable set geom = st_multi(geom);

Nicolas