postgis_srs — Return a metadata record for the requested authority and srid.
setof record postgis_srs(
text auth_name, text auth_srid)
;
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+
Get the metadata for EPSG:3005.
SELECT * FROM postgis_srs('EPSG', '3005'); auth_name | EPSG auth_srid | 3005 srname | NAD83 / BC Albers srtext | PROJCS["NAD83 / BC Albers", ... ]] proj4text | +proj=aea +lat_0=45 +lon_0=-126 +lat_1=50 +lat_2=58.5 +x_0=1000000 +y_0=0 +datum=NAD83 +units=m +no_defs +type=crs point_sw | 0101000020E6100000E17A14AE476161C00000000000204840 point_ne | 0101000020E610000085EB51B81E855CC0E17A14AE47014E40