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