Skip to content

Instantly share code, notes, and snippets.

@geobabbler

geobabbler/simple_spatial_table.sql

Last active March 7, 2017 20:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save geobabbler/6d4fd1127da72201b1aab40db7b279b2 to your computer and use it in GitHub Desktop.
Save geobabbler/6d4fd1127da72201b1aab40db7b279b2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
simple_spatial_table.sql
CREATE TABLE public.simple_table
(
id integer NOT NULL DEFAULT nextval('simple_table_id_seq'::regclass),
message text,
shape geometry(Point,4326),
CONSTRAINT pk_notify PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.simple_table
OWNER TO postgres;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment