pgLatLon
diff create_test_db.schema.sql @ 0:3b70e93cc07d
Version 0.1 (initial commit)
author | jbe |
---|---|
date | Sun Aug 21 17:43:48 2016 +0200 (2016-08-21) |
parents | |
children | 684a78d2f9f0 |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/create_test_db.schema.sql Sun Aug 21 17:43:48 2016 +0200 1.3 @@ -0,0 +1,11 @@ 1.4 + 1.5 +CREATE EXTENSION latlon; 1.6 + 1.7 +CREATE TABLE "test" ( 1.8 + "id" SERIAL4 PRIMARY KEY, 1.9 + "location" EPOINT NOT NULL, 1.10 + "area" ECIRCLE NOT NULL ); 1.11 + 1.12 +CREATE INDEX "test_location_key" ON "test" USING gist ("location"); 1.13 +CREATE INDEX "test_area_key" ON "test" USING gist ("area"); 1.14 +