On Thu, Jul 19, 2012 at 11:35:50AM +0100, Pedro Costa wrote: > Hello people, > > I have one column that is 'MultiLineStringZM'. > How do i turn this geom in 2d?
ALTER TABLE mytable ALTER mycolumn TYPE geometry(MultiLineString) WITH st_force2d(mycolumn); The last one could be "USING" rather than "WITH", and there could be some other SQL syntax error. Refer to PostgreSQL manual abut "ALTER TABLE". --strk; ,------o-. | __/ | Delivering high quality PostGIS 2.1 | / 2.1 | http://strk.keybit.net - http://vizzuality.com `-o------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users