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.

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