> How can I transform the coordinate system of a table ? > I know the SRID is 4326. > > Thanks a lot >
Basically, by using st_transform(geometry, srid) on your table. It may be a little more complicated if you have SRID constraints on your table. 2 options among several: 1°) Drop the constraint, update your data by transforming them, readd the constraint with updated SRID value 2°) Add a new geometric column to your table and insert into it transformed geometries from the first column. HTH Nicolas _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
