Import data into Postgresql

[crs27]

Hai All,

I want to import data from Oracle 10g to POstgreSQl 8.2.Would like to know if their is any way to import data from pgAdmin III.
Thought of using Copy command,but for this the files needs to be either in Ascii or Binary formate.
Kindly suggest me any means of importing data from oracle to postgres.

Thank You

[michaelb]

Look at ora2pg and run a Google search on Postgresql migration or Oracle Postgresql migration - you'll get a number of links to different tools that claim to do the job.