Working with Vector Data –Advanced Recipes - PostGIS - page 238

CREATE TABLE chp04.voronoi_test_points
(
x numeric,
y numeric
)
WITH (OIDS=FALSE);
ALTER TABLE chp04.voronoi_test_points ADD
COLUMN gid serial;
ALTER TABLE chp04.voronoi_test_points ADD
PRIMARY KEY (gid);
INSERT INTO chp04.voronoi_test_points (x, y)
VALUES (5 * random(), 7 * random());
INSERT INTO chp04.voronoi_test_points (x, y)
VALUES (2 * random(), 8 * random());
INSERT INTO chp04.voronoi_test_points (x, y)
VALUES (10 * random(), 4 * random());
INSERT INTO chp04.voronoi_test_points (x, y)
VALUES (1 * random(), 15 * random());
INSERT INTO chp04.voronoi_test_points (x, y)
VALUES (4 * random(), 9 * random());
INSERT INTO chp04.voronoi_test_points (x, y)
VALUES (8 * random(), 3 * random());
INSERT INTO chp04.voronoi_test_points (x, y)
VALUES (5 * random(), 3 * random());
INSERT INTO chp04.voronoi_test_points (x, y)
VALUES (20 * random(), 0.1 * random());
SELECT AddGeometryColumn
('chp04','voronoi_test_points','the_geom',3734,'POINT',2);
UPDATE chp04.voronoi_test_points
SET the_geom = ST_SetSRID(ST_MakePoint(x,y),
3734)
WHERE the_geom IS NULL
;