pgLatLon: 2b7aea022117 create_test

pgLatLon

view create_test_db.schema.sql @ 6:2b7aea022117

Remove version 0.1 files (but keep update script from 0.1 to 0.2); Updated version number in manual installation instructions and include extension update script in manual instructions

author	jbe
date	Mon Aug 22 22:00:21 2016 +0200 (2016-08-22)
parents	3b70e93cc07d
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");