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é.
Try the new Yahoo! India Homepage.
Click here.