liquid_feedback_core
annotate pgLatLon/create_test_db.schema.sql @ 529:96ee2db56bec
New PostgreSQL extension "pgLatLon" for geospatial operations and indexing in LiquidFeedback
| author | jbe |
|---|---|
| date | Thu Aug 18 20:19:58 2016 +0200 (2016-08-18) |
| parents | |
| children |
| rev | line source |
|---|---|
| jbe@529 | 1 |
| jbe@529 | 2 CREATE EXTENSION latlon; |
| jbe@529 | 3 |
| jbe@529 | 4 CREATE TABLE "test" ( |
| jbe@529 | 5 "id" SERIAL4 PRIMARY KEY, |
| jbe@529 | 6 "location" EPOINT NOT NULL, |
| jbe@529 | 7 "area" ECIRCLE NOT NULL ); |
| jbe@529 | 8 |
| jbe@529 | 9 CREATE INDEX "test_location_key" ON "test" USING gist ("location"); |
| jbe@529 | 10 CREATE INDEX "test_area_key" ON "test" USING gist ("area"); |
| jbe@529 | 11 |