You can also add new column in Your table

SELECT
AddGeometryColumn('','table_name','new_column_name','new_SRID','POINT',2);

after that jst do:

UPDATE table_name set new_column_name = Transform(old_geom_column,new_SRID);

after that query You will have 2 columnt: first with old SRID ald second
with new SRID so You can just DROP old column.

Simon
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to