I'm trying to load an Ordnance Survey GML file into PostGIS using the ST_GeomFromGML function. The problem is that the spatial reference system that is used in the file, osgb:BNG, is not recognized by PostGIS:
# SELECT ST_GeomFromGML('<gml:Point srsName="osgb:BNG"> <gml:coordinates>527347.0,181346.0</gml:coordinates></gml:Point>'); ERROR: unknown spatial reference system
Is there any workaround? Does "osgb:BNG" have an alternative name that is recognized by PostGIS? Thank you.
EDIT: Thanks to everybody for their answers. I ended up replacing "osgb:BNG" with "EPSG:27700" in the GML file (in the srsName parameter), although the other two options (modifying the spatial_ref_sys table, or using the ST_GeomFromGML function http://postgis.net/docs/ST_GeomFromGML.html with two arguments for PostGIS 2.0+) are perfectly valid too.