Re: Migrating from Sybase

> > 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-3110: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