[postgis-users] Transform Coordinates

[lisek lichu]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081112/11294992/attachment.html>