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(at)gmail(dot)com> wrote:
From: Andre Lopes <lopes80andre(at)gmail(dot)com>
Subject: [GENERAL] How to import data from Oracle and SqlServer to a Postgres database?
To: pgsql-general(at)postgresql(dot)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/