MSSQL to PostgreSQL

From: "Sidar Lopez Cruz" <sidarlopez(at)hotmail(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: MSSQL to PostgreSQL
Date: 2003-02-24 19:38:35
Message-ID: OE12SVvAyfxRydC3hSs000012ed@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

What do i got to do, when i pass information from mssql to PostgreSQL,

1. i got a text file with this information..
"1-0101-0202","SOME PEOPLE NAME",3
...
this file format was exported from mssql, to text file...
the table definition in PostgreSQL is
create table sujetos (cedula varchar(20), nombre varchar(200), id_tipo_doc bigint);

when i use the command copy into sujetos from ...
i got an error like int8 error .... from PostgreSQL

I try to conver the windows special characters, whit tr in linux, and awk, to form sql syntax and then execute the file with \i in postgresql, but i got an error, because the number of records in text file is 5,000,000

I don't know how to solve the problem...

2. how configure my PostgreSQL to manages dates like (mm/dd/yyyy), or what i got to do?

:-) Sidar Lopez Cruz
- Cero Riesgo, S.A.

Browse pgsql-admin by date

  From Date Subject
Next Message Stephen Harris 2003-02-24 20:27:07 ident sameuser failure
Previous Message Tony Reina 2003-02-24 19:06:14 Encrypting PostgreSQL for Dummies