UpdateGeometrySRID — Updates the SRID of all features in a geometry column, geometry_columns metadata and srid table constraint
text UpdateGeometrySRID(varchar
table_name, varchar
column_name, integer
srid);
text UpdateGeometrySRID(varchar
schema_name, varchar
table_name, varchar
column_name, integer
srid);
text UpdateGeometrySRID(varchar
catalog_name, varchar
schema_name, varchar
table_name, varchar
column_name, integer
srid);
Updates the SRID of all features in a geometry column, updating constraints and reference in geometry_columns. Note: uses current_schema() on schema-aware pgsql installations if schema is not provided.
This function supports 3d and will not drop the z-index.
This method supports Circular Strings and Curves