[postgis-users] multipoint2point

Richard Greenwood richard.greenwood at gmail.com
Mon Sep 14 20:25:13 PDT 2009

You could use st_multi() to cast them al to multi point:

    Returns the geometry as a MULTI* geometry. If the geometry is
already a MULTI*, it is returned unchanged.

SELECT ST_MULTI(wkb_geometry) FROM table;

On Mon, Sep 14, 2009 at 6:22 AM,  <jj.wag at gmx.de> wrote:
> Hi,
> I have a postgistable with different geometrytyps in one table: points and
> multipoints (get this information via ST_GeometryType).
> UMN Mapserver have no problems to show the geometrys, but if I try to export
> this table via ogr2ogr there is an error:
> Attempt to write non-poin(MULTIPOINT) to point shapefile.
> How can I cast all my geometrys to point?
> Jo
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Richard Greenwood
richard.greenwood at gmail.com

More information about the postgis-users mailing list