CREATE TABLE points (id INTEGER, name TEXT); — crea la tabella points com campi id e name ALTER TABLE points ADD COLUMN pt GEOMETRY(Point,0,2); — aggiunge la geometry column sistema riferimento 0 dimensioni 2 INSERT INTO points (id, name, pt) VALUES (1,’Origin’, ST_GeomFromText(‘POINT(0 0)’,0)); INSERT INTO points (id, name, pt) VALUES (2,’First’, ST_GeomFromText(‘POINT(5 0)’,0)); INSERT ...
أكثر...
أكثر...