Search code examples
postgis

Get the SRID of a geometry field

I have a table with some geometry types in and need to be able to return the SRID of a given field. How can I do this. I have had a search but all I can find is the function to alter a SRID. In Oracle I am doing this:

A.CLUSTER_EXTENT.SDO_SRID

Is there an equivalent function in PostGIS?

Solution

  • ST_SRID will give you the SRID of a single geometry. Use Find_SRID for getting the SRID of a column.