Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This question already has an answer here:

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.

share|improve this question

marked as duplicate by Devdatta Tengshe, PolyGeo, Fezter, Aaron, radouxju Feb 28 '14 at 14:52

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

up vote 3 down vote accepted

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.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.