增加geometry类型字段
SELECT AddGeometryColumn ('test1(表名)', 'the_geom', 4326, 'POINT', 2);
插入数据
INSERT INTO test1 (id, the_geom, name) VALUES (1,ST_GeomFromText('POINT(-0.1257 51.508)',4326),'London, England');
INSERT INTO test1 (id, the_geom, name) VALUES (2,ST_GeomFromText('POINT(-81.233 42.983)',4326),'London, Ontario');
INSERT INTO test1 (id, the_geom, name) VALUES (3,ST_GeomFromText('POINT(27.91162491 -33.01529)',4326),'East London,SA');
更新坐标系
UPDATE test1 SET the_geom = ST_SetSRID ( ST_MakePoint ( London, England ), 4326 ) WHERE id=1