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?

3 Answers 3


There is a single line function which does this for you. Just use the following SQL query:

select UpdateGeometrySRID('Schema Name', 'mytable', 'the_geom', newSRID) ;

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:

  1. In the geometry_columns table, update the SRID to the required value.

  2. Drop the contraint on the table, by using the following SQL statement

    ALTER TABLE mytable DROP CONSTRAINT enforce_srid_the_geom;

  3. Update the SRID'd of the geometry by using the following SQL statement

    UPDATE mytable SET the_geom = ST_SetSRID(the_geom, newSRID);

  4. Add the contraint back by using the following SQL statement

    ALTER TABLE mytable

    ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = (newSRID));

  • 2
    See postgis.org/docs/ST_SetSRID.html for more info and links
    – BradHards
    Commented Oct 1, 2012 at 9:12
  • I only use this "UPDATE mytable SET the_geom = ST_SetSRID(the_geom, newSRID);" Commented Mar 31, 2020 at 2:18
  • @MdAmiruzzamanThis question is from the 1.x version of PostGIS, where the geometries_columns table was used; Now with 2.x, with this table not being used, you don't need to go via such a long process, but if you have constraint on your table, then that needs to be updated as well Commented Mar 31, 2020 at 10:45
  • 2
    UpdateGeometrySRID don't work if you have view on table. you need drop all views using your table before update geometry and them recreate all your views Commented Aug 21, 2020 at 7:46
  • postgis.net/docs/ST_SetSRID.html -- link has moved
    – jcollum
    Commented Oct 24, 2023 at 19:19

With PostGIS 2.x, geometry columns typically use typmods like geometry(Point, 1234). For these you can use ALTER TABLE to directly modify the geometry column type in one step.

For example, to set the SRID of geom in mytable to WGS84, use ST_SetSRID:

    TYPE geometry(Point, 4326)
    USING ST_SetSRID(geom, 4326);

Note that this will only alter the SRID, but not transform the coordinate data.

  • 2
    With a trivial change, this will also work with geography columns, which UpdateGeometrySRID does not support.
    – dsz
    Commented Jan 31, 2019 at 3:16
ALTER TABLE public.kltask ALTER COLUMN geom TYPE geometry(Point, 4326) USING ST_SetSRID(geom, 4326);

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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