5

I've been told to use AddGeometryColumn to properly add a column with correct/preferred SRID. however I wonder if it's possible to fix/change the current column instead of adding a new? If there's no other way but to use this function should I remove the previous column?

Thanks a ton.

Kourosh
  • 1,299
  • 1
  • 12
  • 13

1 Answers1

4

You need to use UpdateGeometrySRID.

If you are just correcting a mistake, that's fine. If not you also need to use ST_Transform (the documentation explains this).

Also see this post.

Lee Goddard
  • 512
  • 1
  • 4
  • 14
MappaGnosis
  • 33,857
  • 2
  • 66
  • 129