postgis_srs
Name
postgis_srs — Return a metadata record for the requested authority and srid.
Synopsis
setof record
postgis_srs
(
text
auth_name
, text
auth_srid
)
;
Description
Returns a metadata record for the requested
auth_srid
for the given
auth_name
. The record will have the
auth_name
,
auth_srid
,
srname
,
srtext
,
proj4text
, and the corners of the area of usage,
point_sw
and
point_ne
.
Availability: 3.4.0
Proj version 6+
Examples
Get the metadata for EPSG:3005.
Code
SELECT auth_name, auth_srid, srname,point_sw AS point_sw,point_ne AS point_ne
FROM postgis_srs('EPSG', '3005');