Find_SRID
Prev 9. Miscellaneous Functions Next

Name

Find_SRID — Returns the SRID of the specified geometry column by searching through the metadata GEOMETRY_COLUMNS table.

Synopsis

integer Find_SRID(varchar table_schema, varchar table_name, varchar geometry_field);

integer Find_SRID(varchar table_name, varchar geometry_field);

Alias

-

Description

Returns the SRID of the specified geometry column by searching through the metadata GEOMETRY_COLUMNS table. To obtain a successful result, the geometry column must be properly added with the AddGeometryColumn function

The parameters needed are table schema (optional), table name, and geometry column.

Coordinate Dimensions
2D3DM
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

--PostgreSQL
SELECT Find_SRID('public', 'mytable', 'geometry_field');
SELECT Find_SRID('mytable', 'geometry_field');

--H2
SELECT Find_SRID('mytable', 'geometry_field');
SELECT Find_SRID('PUBLIC', 'mytable', 'geometry_field');

Related functions

ST_SRID

Prev Up Next
ST_Extent3D Home ST_Mem_Size