https://wiki.janforman.com/ 2026-05-05T03:24:27+00:00 FeedCreator 1.8 (info@mypapit.net) 2022-05-06T11:50:05+00:00 2022-05-06T11:50:05+00:00 https://wiki.janforman.com/gis:postgis Anonymous anonymous@undisclosed.example.com Add geometry with X,Y columns ALTER TABLE your_table ADD COLUMN geom geometry(Point, 4326); UPDATE your_table SET geom = ST_SetSRID(ST_MakePoint(longitude, latitude), 4326); Auto regenerate X,Y while inserting PostgreSQL 12+ ALTER TABLE test ADD COLUMN geom geometry(Point,5514) GENERATED ALWAYS AS (ST_SetSRID(ST_MakePoint(jtsk_x, jtsk_y), 5514)) STORED

Add geometry with X,Y columns ALTER TABLE your_table ADD COLUMN geom geometry(Point, 4326); UPDATE your_table SET geom = ST_SetSRID(ST_MakePoint(longitude, latitude), 4326); Auto regenerate X,Y while inserting PostgreSQL 12+ ALTER TABLE test ADD COLUMN geom geometry(Point,5514) GENERATED ALWAYS AS (ST_SetSRID(ST_MakePoint(jtsk_x, jtsk_y), 5514)) STORED