[Gambas-user] [Gambas Bug Tracker] Bug #1296: not able to use db.find or sql.request with postgreSQL

bugtracker at gambaswiki.org bugtracker at gambaswiki.org
Mon Apr 16 20:24:17 CEST 2018


http://gambaswiki.org/bugtracker/edit?object=BUG.1296&from=L21haW4-

Comment #13 by Michael ALTROGGE:

pgadmin III claims that this will create the schema:

-- Schema: test

-- DROP SCHEMA test;

CREATE SCHEMA test
  AUTHORIZATION "NSAP";                             <-- change to fit your needs


this will create the table:

-- Table: "test"."MA00"

-- DROP TABLE "test"."MA00";

CREATE TABLE "test"."MA00"
(
  "INDX" serial NOT NULL,
  "MNDT" integer,
  "AS4LOCAL" character varying(2) NOT NULL,
  "AS4VERS" character(8),
  "MDL" character varying(64) NOT NULL,
  "TNR" integer NOT NULL,
  "HDR" character varying(30) NOT NULL,
  "TXT" character varying(5000) NOT NULL,
  "AS4USER" character(12) NOT NULL,
  "AS4DATE" date NOT NULL,
  "AS4TIME" time without time zone NOT NULL,
  CONSTRAINT "MA00-PK" PRIMARY KEY ("INDX")
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "test"."MA00"
  OWNER TO NSAP;                                      <-- change to fit your needs

and this will insert a row

INSERT INTO "test"."MA00"(
            "INDX", "MNDT", "AS4LOCAL", "AS4VERS", "MDL", "TNR", "HDR", "TXT", 
            "AS4USER", "AS4DATE", "AS4TIME")
    VALUES (1,1000,'DE','1.00.00 ','ADRESSEN',2,'Testtitel','Testeintrag','1000        ','2018-04-16','04:10:00');


Hope that this time I got everything right ...
Interesting (for me) was that pgadmin  quotet the schema test with " (double) but the schema public is not quotet ...

Michael ALTROGGE changed the state of the bug to: Accepted.




More information about the User mailing list