title: How to change SRID of geometry column?
body: <p>I have a table where one of the columns is a geometry column <code>the_geom</code> for polygons with an SRID. I added a new column in the same table with exactly the same geometry data as <code>the_geom</code>.</p>
  
  <p>This new column has the name <code>the_geom4258</code> because I want to set its SRID to 4258. What is the procedure to change the geometry's SRID to another coordinate system? Is it enough to apply the following query:</p>
  
  <pre><code>UPDATE table SET the_geom4258=ST_SetSRID(the_geom4258,4258);
  </code></pre>