Re: Migrating from Sybase

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

In response to

Browse pgsql-general by date

  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