thursday tip day postgis geometry transforms
How to transform the geometry of a postgis table from one projection to another:
postgisdbf=# UPDATE your_table SET the_geom = TRANSFORM(the_geom, 4326);
Where the_geom is the name of the field holding the geometry, and 4326 is the EPSG code you wish to transform to
Read other posts