snippet.sql
UPDATE
icp
.
camera_info
SET
geom
=
ST_SetSRID
(
ST_Point
(
lon_x
,
lat_y
)
,
4326
)