Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group