Name

postgis_srs_codes — Return the list of SRS codes associated with the given authority.

Synopsis

setof text postgis_srs_codes(text auth_name);

설명

Returns a set of all auth_srid for the given auth_name.

Availability: 3.4.0

Proj version 6+

예시

List the first ten codes associated with the EPSG authority.

SELECT * FROM postgis_srs_codes('EPSG') ORDER BY 1 LIMIT 10;
10156
 10157
 10158
 10160
 10162
 10163
 10164
 10165
 10166
 10167