[postgis-users] SRS WKT >>> srid?

[Patrick]

Hi all,

If I have a shapefile with an associated coordinate system string as a WKT,
how do I find the corresponding srid in spatial_ref_sys?

It appears to me that spatial_ref_sys is currently not particularly
efficient, certainly not normalized, and potentially (see question above)
not very suitable for querying (i.e. find me all SRSs based on the Everest
datum). Are there maybe some functions that support SRS analysis that I
missed?

Patrick