Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

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;

Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified
Image Modified