描述

从知名文本或扩展知名表示中返回地理对象。如果未指定，则假定为SRID 4326。这是ST_Gegraph yFromText的别名。分数总是以较长的后期形式表示。

示例

--- converting lon lat coords to geography
ALTER TABLE sometable ADD COLUMN geog geography(POINT,4326);
UPDATE sometable SET geog = ST_GeogFromText('SRID=4326;POINT(' || lon || ' ' || lat || ')');

--- specify a geography point using EPSG:4267, NAD27
SELECT ST_AsEWKT(ST_GeogFromText('SRID=4267;POINT(-77.0092 38.889588)'));
                        

另请参阅

ST_AsText , ST_GeographyFromText