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?
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:
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.