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

[bugtracker at gambaswiki.org]

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.