Contents
Table of Contents | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
Code Block |
---|
CREATE TABLE "TEST01" () WITH (OIDS=FALSE); ALTER TABLE "TEST01" OWNER TO postgres; ALTER TABLE "TEST01" ADD COLUMN "ObservationID" integer; ALTER TABLE "TEST01" ALTER COLUMN "ObservationID" SET NOT NULL; CREATE SEQUENCE "TEST01_ObservationID_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 6 CACHE 1; ALTER TABLE "TEST01_ObservationID_seq" OWNER TO postgres; ALTER TABLE "TEST01" ALTER COLUMN "ObservationID" SET DEFAULT nextval('"TEST01_ObservationID_seq"'::regclass); ALTER TABLE "TEST01" ADD CONSTRAINT "TEST01_pkey" PRIMARY KEY("ObservationID" ); ALTER TABLE "TEST01" ADD COLUMN "Value" real; |