postgis_srs_codes — Return the list of SRS codes associated with the given authority.
setof text postgis_srs_codes(text auth_name);
setof text postgis_srs_codes(
)
Returns a set of all auth_srid for the given auth_name.
auth_srid
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') LIMIT 10; postgis_srs_codes ------------------- 2000 20004 20005 20006 20007 20008 20009 2001 20010 20011
postgis_srs, postgis_srs_all, postgis_srs_search