pgLatLon
view create_test_db.schema.sql @ 40:f1a9a5de9a12
Removed files for old version 0.7; Updated README, GNUmakefile, and control file to version 0.8
| author | jbe |
|---|---|
| date | Fri Oct 21 12:56:11 2016 +0200 (2016-10-21) |
| parents | 684a78d2f9f0 |
| children | 3cbce515387f |
line source
2 CREATE EXTENSION latlon;
4 CREATE TABLE "test" (
5 "id" SERIAL4 PRIMARY KEY,
6 "location" EPOINT NOT NULL,
7 "surrounding" ECIRCLE NOT NULL,
8 "multipoint" ECLUSTER NOT NULL,
9 "triangle" ECLUSTER NOT NULL );
11 CREATE INDEX "test_location_key" ON "test" USING gist ("location");
12 CREATE INDEX "test_surrounding_key" ON "test" USING gist ("surrounding");
13 CREATE INDEX "test_multipoint_key" ON "test" USING gist ("multipoint");
14 CREATE INDEX "test_triangle_key" ON "test" USING gist ("triangle");