Getting SRID Well Known Text (WKT) metadata from PostgreSQL?

Question

The SRID metadata is showed by, e.g., this web page:

_{Definition: Well Known Text (WKT)}

_{PROJCS["UTM Zone 24, Northern Hemisphere",
GEOGCS["GRS 1980(IUGG, 1980)",
DATUM["unknown",
SPHEROID["GRS80",6378137,298.257222101],
TOWGS84[0,0,0,0,0,0,0]],
PRIMEM["Greenwich",0],
UNIT["degree",0.0174532925199433]],
PROJECTION["Transverse_Mercator"],
PARAMETER["latitude_of_origin",0],
PARAMETER["central_meridian",-39],
PARAMETER["scale_factor",0.9996],
PARAMETER["false_easting",500000],
PARAMETER["false_northing",0],
UNIT["Meter",1],
AUTHORITY["epsg","6211"]]}

This information is on my local database, but how can I see it?

A function like SRID_AsText(srid). Or some complex PostgreSQL query over all PostGIS tables to see the SRID metadata?

Answer 1

This page should have what you're after, the spatial_ref_sys table in PostGIS:

https://postgis.net/docs/using_postgis_dbmanagement.html#spatial_ref_sys