Re: Migrating from Sybase - Mailing list pgsql-general

From Jens P. Elsner
Subject Re: Migrating from Sybase
Date
Msg-id 20000725003236.A2444@ice.anydomain
Whole thread Raw
In response to RE: Migrating from Sybase  (Bill Barnes <bbarnes@operamail.com>)
List pgsql-general
> Had a similar experience in Postgresql 6.5.3 running in Linux with *.dat files
> coming from Sybase running in win95.
>
> Found that if I split the source file with a text editor that the individual
> splits would process ok.  Finally concluded that Sybase was putting a
> character at end of file that 'COPY' could not interpret.
At the end of each line, the <cr>. recode fixed it.

> Also, had trouble with null fields.  I had Sybase generate a unique date for
> nulls and 0 for null integers.  But then, my 'copy' command didn't include
> 'with null as ''.
Ok.

> Further, changed all char fields to varchar because postgres stumbled on
> character lengths that didn't match char(length).
No problem with that.

> Hope this helps.
Yup, thanks a lot!

JP

pgsql-general by date:

Previous
From: "Timothy H. Keitt"
Date:
Subject: Re: Statistical Analysis
Next
From: "Jens P. Elsner"
Date:
Subject: Re: Migrating from Sybase