Table

gistfile1.txt

CREATE TABLE pois
(
  id serial NOT NULL,
  name text NOT NULL,
  created_at timestamp without time zone NOT NULL,
  updated_at timestamp without time zone NOT NULL,
  "position" geography(Point,4326),
  CONSTRAINT pois_pkey PRIMARY KEY (id ),
  CONSTRAINT pois_name_key UNIQUE (name )
)
WITH (
  OIDS=FALSE
);

CREATE INDEX position_gix
  ON pois
  USING gist
  ("position" );