以下追加と更新
alter table your_table add column geom geometry(Point, 4326);
update mst_city set geom=st_SetSrid(st_MakePoint(lat, lng), 4326);
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme