[postgis-users] RE : How to change the SRID of a table ingeometry_columns view

Francois Hugues hugues.francois at irstea.fr
Fri Sep 14 00:45:57 PDT 2012


I think you do not have to change the view but only update the original table using st_SetSRID (http://postgis.org/docs/ST_SetSRID.html) and the view should be automatically update.

To change the SRID from your table you will certainly have to remove constraints first.


-------- Message d'origine--------
De: postgis-users-bounces at postgis.refractions.net de la part de Stefan Schwarzer
Date: ven. 14/09/2012 09:36
À: PostGIS Users Discussion
Objet : [postgis-users] How to change the SRID of a table ingeometry_columns view
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,

postgis-users mailing list
postgis-users at postgis.refractions.net

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3371 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120914/78cbd59f/attachment.bin>

More information about the postgis-users mailing list