ST_AsText – represent geometry as WKT

ST_Transform – transform geometry from one projection to another

ST_GeomFromText – represent WKT as geometry

SELECT ST_AsText(ST_Transform(ST_GeomFromText(ST_AsText(geometry_column),900913), 4326)) from TABLE_NAME;

Reference: PostGIS 1.5 Manual