只需对函数ST_GeomFromGeoJSON进行更新：

UPDATE mytable SET geom = ST_GeomFromGeoJSON(json_column);

以下示例将GeoJSON点插入JSON列，然后使用上述函数更新几何列。

CREATE TEMPORARY TABLE mytable(
json_column json,
geom geometry);

INSERT INTO mytable (json_column) VALUES ('{
    "type": "Point",
    "coordinates": [7.0069, 51.1623]
}'); 

UPDATE mytable SET geom = ST_GeomFromGeoJSON(json_column);

SELECT * FROM mytable;

             json_column              |                    geom                    
--------------------------------------+--------------------------------------------
 {                                   +| 01010000009E5E29CB10071C400612143FC6944940
     "type": "Point",                +| 
     "coordinates": [7.0069, 51.1623]+| 
 }                                    | 
(1 Zeile)