mercredi 25 mars 2015

How to populate a table with geom line?


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