From: | "Jens P(dot) Elsner" <jpelsner(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Migrating from Sybase |
Date: | 2000-07-24 22:33:41 |
Message-ID: | 20000725003341.B2444@ice.anydomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> > 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
>
> I think it's unhappy about the last field, for which you're supplying an
> empty string --- but the field is declared 'smallint' and so an empty
> string isn't valid. Postgres does not consider an empty string to mean
> NULL. You should write \N if you want COPY to produce a NULL.
I used " with null as ''".
> BTW, I do not know whether the '^M's in your message were actually in
> the original file, but that could be a problem too. I haven't tried it,
> but I think that COPY wants Unix-style newlines (LF only) and is not
> forgiving about accepting DOS-style newlines instead.
That fixed it ! Thanks! recode d it and it was ok.
JP
From | Date | Subject | |
---|---|---|---|
Next Message | Aaron Sethman | 2000-07-24 22:37:47 | Re: password encryption |
Previous Message | Jens P. Elsner | 2000-07-24 22:32:37 | Re: Migrating from Sybase |