[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
Hello,
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.
Hugues.
-------- 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,
Stef
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- 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