Devart Forums

Code: Select all

CREATE DATABASE myDB
  WITH OWNER = postgres
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       LC_COLLATE = 'French_France.1252'
       LC_CTYPE = 'French_France.1252'
       CONNECTION LIMIT = -1;
GRANT ALL ON DATABASE myDB TO public;
GRANT ALL ON DATABASE myDB TO postgres;

CREATE TABLE public.evenements (
  ligne VARCHAR(50) NOT NULL,
  id_multicn INTEGER DEFAULT 0 NOT NULL,
  date_debut_evenement TIMESTAMP WITHOUT TIME ZONE NOT NULL,
  date_fin_evenement TIMESTAMP WITHOUT TIME ZONE,
  duree_evenement TIME WITHOUT TIME ZONE,
  id_statut_machine INTEGER NOT NULL,
  id_evenement_multicn INTEGER NOT NULL,
  id_evenement_pilote INTEGER,
  id_poste INTEGER NOT NULL,
  date_poste DATE NOT NULL,
  heure_debut_production TIME WITHOUT TIME ZONE DEFAULT '00:00:00'::time without time zone,
  heure_fin_production TIME WITHOUT TIME ZONE DEFAULT '00:00:00'::time without time zone,
  id_pilote_1 VARCHAR(100) NOT NULL,
  id_pilote_2 VARCHAR(100) NOT NULL,
  duree_production TIME WITHOUT TIME ZONE DEFAULT '00:00:00'::time without time zone,
  duree_piquage TIME WITHOUT TIME ZONE DEFAULT '00:00:00'::time without time zone,
  ordre_fabrication VARCHAR(6),
  compteur_produit INTEGER DEFAULT 0,
  point REAL DEFAULT 0,
  piquage VARCHAR(100),
  cadence_moyenne REAL DEFAULT 0,
  cadence_max REAL DEFAULT 0,
  longueur_deroulee REAL DEFAULT 0,
  plateau VARCHAR(50) DEFAULT ''::character varying,
  compteur_plateau INTEGER DEFAULT 0,
  arret_en_cours BOOLEAN NOT NULL,
  version VARCHAR(50) DEFAULT ''::character varying,
  date_export TIMESTAMP(0) WITHOUT TIME ZONE,
  reference_export VARCHAR(50),
  date_import TIMESTAMP(0) WITHOUT TIME ZONE,
  reference_import VARCHAR(50),
  cadence_instantanee REAL DEFAULT 0,
  point_reel REAL DEFAULT 0,
  position_x REAL DEFAULT 0,
  position_y REAL DEFAULT 0,
  longueur_piquage REAL DEFAULT 0,
  CONSTRAINT evenements_pkey PRIMARY KEY(ligne, date_debut_evenement, date_poste, id_poste, id_pilote_1, id_pilote_2, id_statut_machine, arret_en_cours, id_multicn, id_evenement_multicn)
) 
WITH (oids = false);

Code: Select all

INSERT INTO "evenements" VALUES ('PICPIC 3', '9', '2015-09-23 01:50:16', '2015-09-23 01:52:59', '00:02:43', '1', '-1', NULL, '3', '2015-09-23', '01:16:59', NULL, '26', '52', '00:33:16.189', '02:39:52.204', '359007', '19', '5', E'P:\\Carreaux\\CARREAUX_pav?25x28 coupe 2.7 avec z?o.mcn', '2.04', '3.21', '67.72', 'G20', '19', 'f', '1.0.0.90', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Code: Select all

object UniConnection1: TUniConnection
  ProviderName = 'PostgreSQL'
  Database = 'myDB'
  SpecificOptions.Strings = (
    'SQLite.BusyTimeout=10000'
    'SQLite.EnableSharedCache=True'
    'SQLite.UseUnicode=True'
    'SQLite.Direct=True'
    'SQLite.ReadUncommitted=True'
    'PostgreSQL.Charset=WIN1252'
    'PostgreSQL.ApplicationName=App'
    'PostgreSQL.UseUnicode=True')
  Options.KeepDesignConnected = False
  Username = 'postgres'
  Server = 'localhost'
  LoginPrompt = False
  Left = 24
  Top = 8
  EncryptedPassword = 'xyz'
end



object udBackup: TUniDump
  Connection = UniConnection1
  Options.QuoteNames = True
  Left = 64
  Top = 304
end

Code: Select all

    'PostgreSQL.Charset=WIN1252'
    'PostgreSQL.UseUnicode=True'