[postgis-users] Transform Coordinates

[Nicolas Ribot]

> 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