Skip to content

Instantly share code, notes, and snippets.

SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "transactiontest" (gid serial,
"id" varchar(200),
"name" varchar(20),
"cdd" float8,
"timestamp" timestamp);
ALTER TABLE "transactiontest" ADD PRIMARY KEY (gid);
SELECT AddGeometryColumn('','transactiontest','geom','26912','POINT',2);