I run PostgreSQL 9.1 and PostGIS 2.0. I have a table that contains one geometry column.
But that column contains point, polygons lines, etc.
So I set it like so,
ALTER TABLE jake ADD COLUMN jake_geom geometry;
and then I setted some constraints to make it geometry enabled, but not limited on a single geometry type
ALTER TABLE jake ADD CONSTRAINT enforce_dims_geom CHECK (st_ndims(jake_geom) = 2); ALTER TABLE jake ADD CONSTRAINT enforce_srid_geom CHECK (st_srid(jake_geom) = 900913);
Now, I want to reproject the geometries in that column to
According to this, for the transform to work, I need to set a geometry type.
TYPE geometry(MultiPolygon,2163) part)
but my column does not have certain geometry type. How do I proceed?
Or I can simply do
ALTER COLUMN geom USING ST_Transform(geom,2163);
avoiding to set a type?