pgLatLon

view 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 source
2 CREATE EXTENSION latlon;
4 CREATE TABLE "test" (
5 "id" SERIAL4 PRIMARY KEY,
6 "location" EPOINT NOT NULL,
7 "area" ECIRCLE NOT NULL );
9 CREATE INDEX "test_location_key" ON "test" USING gist ("location");
10 CREATE INDEX "test_area_key" ON "test" USING gist ("area");

Impressum / About Us