I believe this topic is quite frequently asked here or in the postgresql mailing list . I have searched this forum and have indeed asked the question at postgresql mailing list but couldn't get any other answer except suggestions to check on techdocs. The problem is, out of 4 links to the articles, only one is ok, whereas other 3 links are dead links..
so, any other pointers on where can I dig up some more info on the topic?
I see that u want to do it really the easiest way to do that is simply to do it through ODBCs , u install the Oracle ODBC , and the Pgsql ODBC , then migrate with a simple software or just a vb or c program that you'll create you're self, I'll advice you agin http://www.dbtools.com.br wich treats Postgresql bu have very big posiblities of migration, u can import you DB from :
A Text file with sparators (usually | the pipe)
From an Excel file .
From a dbase 3/4/5 DB (oracle is able to export one)
Or just from an existing ODBC , wich is the easiest way.
Following on from the previous poster, you need both ODBC drivers for Postgres and Oracle. With Virtuoso, a tool by the company I work with, OpenLink Software, you can link in tables from both sources and replicate data between the two at regular intervals if you wish.