Application: gvSIG desktop » gvSIG data provider for PostgreSQL

-- Insert SQL

INSERT INTO "dbtest"."public"."test" ( 

      "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", 

      "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", 

      "Decimal", "Geometry" 

  ) VALUES ( 

    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ST_GeomFromWKB((?), (?)) 

  );

-- Delete SQL

DELETE FROM "dbtest"."public"."test" WHERE ( ("ID") = (?) );

-- Update SQL

UPDATE "dbtest"."public"."test" 

  SET 

    "Byte" = ?, 

    "Bool1" = ?, 

    "Long" = ?, 

    "Timestamp" = ?, 

    "Date" = ?, 

    "Time" = ?, 

    "Bool2" = ?, 

    "String" = ?, 

    "Bool3" = ?, 

    "Double" = ?, 

    "Bool4" = ?, 

    "Float" = ?, 

    "Bool5" = ?, 

    "Decimal" = ?, 

    "Geometry" = ST_GeomFromWKB((?), (?)) 

  WHERE 

    ( ("ID") = (?) );

-- Update Table SQL

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Byte" TINYINT DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Bool1" BOOLEAN DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Long" BIGINT DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Timestamp" TIMESTAMP DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Date" DATE DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Time" TIME DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Bool2" BOOLEAN DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "String" VARCHAR(30) DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Bool3" BOOLEAN DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Double" DOUBLE PRECISION DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Bool4" BOOLEAN DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Float" REAL DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Bool5" BOOLEAN DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Decimal" NUMERIC(6,3) DEFAULT NULL NULL;

ALTER TABLE "dbtest"."public"."test" ADD COLUMN "Geometry" TEXT DEFAULT NULL NULL;

-- FIXME: El ALTER TABLE de una columna geometria no funciona