Migrating from Sybase

From: "Jens P(dot) Elsner" <jpelsner(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Migrating from Sybase
Date: 2000-07-23 19:36:37
Message-ID: 20000723213637.A480@ice.anydomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I ran into some trouble moving my data from a Sybase ADA db to Postgresql.
I fixed most of the problems (to move the data I unloaded the db and edited
the scripts), but there's one I'm stuck with:

The command:

COPY probe FROM '/home/ice/felsdb/186.dat' using delimiters '|' with null as '' ;

produces

": can't parse "elsdb/import3.sql:419: ERROR: copy: line 1, pg_atoi: error in "":

The stuff in 186.dat:

WI-02.06.99-029|1999-06-02 11:04:13.184|Werk 1 Mue|KStK00-32/1|Mineralgemisch 0-30mm|||Halde B2, neue Anlage|1999-05-31 10:53:00.000|9922|1999-06-02||WP_B2||Manschke|3|1|A0170938384B|^M

[....]

The DB table "probe":

CREATE TABLE "probe"^M
(^M
"probennummer" char(20) NOT NULL,^M
"eingang_am" timestamp NOT NULL,^M
"kunden_nr" char(20) NULL,^M
"produktgruppe" char(20) NOT NULL,^M
"beschreibung" varchar(40) NULL,^M
"chargen_nr" varchar(20) NULL,^M
"lieferschein_nr" varchar(20) NULL,^M
"entnahmeort" varchar(40) NULL,^M
"entnommen_am" timestamp NULL,^M
"kalenderwoche" integer NULL,^M
"ankunft_am" date NULL,^M
"fertig_am" timestamp NULL,^M
"jobname" char(20) NULL,^M
"vermerk" varchar(40) NULL,^M
"registriert_von" varchar(25) NULL,^M
"type" smallint NOT NULL,^M
"status" smallint NOT NULL,^M
"barcode" char(12) NULL,^M
"mark" smallint NULL,^M
PRIMARY KEY ("probennummer", "eingang_am")^M
);

What am I doing wrong here?

JP

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Barnes 2000-07-23 20:13:06 RE: Migrating from Sybase
Previous Message Jan Wieck 2000-07-23 19:26:23 Re: failed Delete after Insert in a transaction