How to change SRID of geometry column?

Posted by Z77 on Stack Overflow See other posts from Stack Overflow or by Z77
Published on 2010-06-10T08:16:52Z Indexed on 2010/06/10 8:22 UTC
Read the original article Hit count: 251

Filed under:
|

I have table where the one of columns is geometry column the_geom for polygons with SRID. I added new column in the same table with exactly the same geometry data as in the_geom. This another column has name the_geom4258 because I want here to set up another SRID=4258. So what is the procedure to set up another SRID geometry to be changed (in another coord.system)? Is just enough to apply following query:

UPDATE table SET the_geom4258=ST_SetSRID(the_geom4258,4258);

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about postgis