[QGIS-pt] Postgis: alterar coluna de polygon para multipolygon

[Fred Lehodey]

Olá,
- pode adicionar uma coluna geom_temp de type multipolygon
- update geoffreo set geom_temp= st_multi( thegeom_ffr)
- drop thegeom_ffr
- rename geom_temp to thegeom_ffr

Abr.


On Mon, Jun 23, 2014 at 5:44 PM, Pedro <pedro.ferro at gmail.com> wrote:

> Viva,
>
> Tenho uma coluna que está como poligono e preciso de alterá-la para
> multipoligono.
> Pensava que seria assim:
> /alter table geoffreo alter column "thegeom_ffreo" type
> geometry(MultiPolygon);/
>
> mas dá-me o erro:
> /ERROR:  Geometry type (Polygon) does not match column type (MultiPolygon)/
>
> sabem como devo fazê-lo?
>
> obrigado,
> Pedro
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Postgis-alterar-coluna-de-polygon-para-multipolygon-tp5147362.html
> Sent from the QGIS-pt mailing list archive at Nabble.com.
> _______________________________________________
> QGIS-pt mailing list
> QGIS-pt at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/qgis-pt
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-pt/attachments/20140623/a70e0762/attachment.html>