I have coordinat of lot of points in a table, in pgadmin and I want to make a line that passes between these points. So, I want to update the geom geometry column with line geom.
I have done this query:
SELECT AddGeometryColumn('MyTable', 'geom', 32634, 'LINESTRING', 2); UPDATE "MyTable" SET geom = ST_SetSRID(ST_MakeLINE((ST_MakePOINT1("X", "Y"), ST_MakePOINT2("X", "Y")), 32634));
but it doesn't work. Can anyone help me please?
Aucun commentaire:
Enregistrer un commentaire