How to import data from Oracle and SqlServer to a Postgres database?

One way is that take the dump of oracle in .csv format

Import data into postgres database using copy command.

--
Thanks
Sam Jas

--- On Fri, 6/11/09, Andre Lopes <lopes80andre@gmail.com> wrote:

From: Andre Lopes <lopes80andre@gmail.com>
Subject: [GENERAL] How to import data from Oracle and SqlServer to a Postgres database?
To: pgsql-general@postgresql.org
Date: Friday, 6 November, 2009, 12:03 PM

Hi,

I have one oracle database and one database in sqlserver with data that I need to import to Postgres. Wich is the best way to import data to Postgres?

Sorry for my english.

Best Regards,
André.

Connect more, do more and share more with Yahoo! India Mail. Learn more. http://in.overview.mail.yahoo.com/

On Fri, Nov 06, 2009 at 12:03:49PM +0000, Andre Lopes wrote:

Hi,

I have one oracle database and one database in sqlserver with data
that I need to import to Postgres. Wich is the best way to import
data to Postgres?

One way is to use DBI-Link. DBI-Link connects from PostgreSQL to the
remote database and allows you to import data from it.

Sorry for my english.

I assure you, my Spanish is much worse, and my Portuguese is purely a
caution ;)

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate