PostGIS

postgis_srs_codes

Prev

7.7. Spatial Reference System Functions

Next

Name

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

Synopsis

setof text +`*`+postgis_srs_codes*(`text `auth_name`)`;

Description

Returns a set of all auth_srid for the given auth_name.

Availability: 3.4.0

Proj version 6+

Examples

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

See Also

postgis_srs, postgis_srs_all, postgis_srs_search

Prev

Up

Next

ST_TransformPipeline

Home

postgis_srs