While importing my shapefile data to PostGIS, I did not select the proper Projection.
How do I now change the SRID of the data, without transforming the Coordinates?
With PostGIS 2.x, geometry columns typically use typmods like
For example, to set the SRID of
Note that this will only alter the SRID, but not transform the coordinate data.
There is a single line function which does this for you. Just use the following SQL query:
But, if you are like me, you would be interested in the low level, miniature steps. Logically speaking, the above function is equivalent to the following four step process: