Hi, This is now possible thanks to the typemods, by altering the column:
alter table mytable ALTER COLUMN geom TYPE geometry(MultiPolygon,2154) USING ST_setSRID(geom, 2154); (replacing the type by the one of the geom column) Nicolas On 14 September 2012 09:36, Stefan Schwarzer <stefan.schwar...@unep.org> wrote: > Hi there, > > I'd need to change the SRID of a table, as it is "0" in the moment, and > should be something else. I searched around, but couldn't really find clear > guidance on how to do this with Postgis 2.x, as the "geometry_columns" is now > a view and not anymore a table. > > I guess there is a simple SQL for that? A UpdateGeometrySRID or so? > > Thanks for any hints, > > Stef > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
