UpdateGeometrySRID

UpdateGeometrySRID
Prev	1. Management Functions	Next

Name

UpdateGeometrySRID — Updates the SRID of the geometries in a particular geometry column. It also updates the geometry_columns metadata table and the srid table constraint.

Synopsis

varchar UpdateGeometrySRID(varchar catalogue, varchar schema, varchar table, varchar column, integer srid);

varchar UpdateGeometrySRID(varchar schema, varchar table, varchar column, integer srid);

varchar UpdateGeometrySRID(varchar table, varchar column, integer srid);

Description

Updates the SRID of the geometries in a particular geometry column. It also updates the geometry_columns metadata table and the srid table constraint.


	This function does not reproject geometries, it just changes the SRID values.

Coordinate Dimensions

2D	3D	M

Spatial Standards Support

OGC SFS for SQL. 1.1 (1999)	OGC SFS for SQL. 1.1.0 (2005)	OGC SFS for SQL. 1.2.0 (2006)	SQL-MM Part 3
-	-	-	-

Examples

create table "test" (id serial PRIMARY KEY);
SELECT AddGeometryColumn ('test','geom',-1,'MULTIPOINT',3);
SELECT UpdateGeometrySrid('test','geom',23030);
SELECT DropGeometryTable ('test');

Related functions

ST_SetSRID