Re: transfer data from oracle to postgres

Hi Sarah,

These is some information about converting from Oracle to PostgreSQL
here:

http://techdocs.postgresql.org/

On the front page there is a section called "Converting from other
Databases to PostgreSQL" and there is information there about converting
from Oracle to PostgreSQL.

Under the category of "Non-specific", there is a link to a conversion
guide by the pgAdmin development team which might also prove to be
useful (not sure).

Hope that helps.

:-)

Regards and best wishes,

Justin Clift


s wrote:
>
> Is there an easy way to transfer DATA from an oracle database to a
> postgres database (tables are already created)?  As far as I can tell
> the oracle export creates a binary file.  I could write a script, but
> it would be a bit tedious.  I imagine it has already been done?
>
> I searched the archives and docs and the web, but the archives are
> coming up quite right on my browser and I didn't find any good
> suggestions.
>
> thanks,
>
> Sarah
> smarie@ekno.com
>
> ____________________________________________________________________________
> Lonely Planet's ekno - more than a phonecard
> Get ekno before you go!
> http://www.ekno.lonelyplanet.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi