Dump from mssql

From: "Sidar Lopez Cruz" <sidarlopez(at)hotmail(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Dump from mssql
Date: 2003-02-26 18:46:19
Message-ID: OE65eQ6ThLjmSFXLNms0000968c@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

how can i dump plaint text files from mssql to postgresql 7.3
the file format is...

"555555555","some people name",3
....

the table in mssql is

create table people (id varchar(20),name varchar(200),id_document bigint)
and the same in postgresql

remember that the file was generated by mssql with data transformation program (DTS)

S.O.S. i need to do this... for begin in postgresql?

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Murthy Kambhampaty 2003-02-26 21:51:13 Dump/restoring a given table in a given schema
Previous Message Robert Treat 2003-02-26 18:25:35 Re: CREATE OR REPLACE TABLE ...