Re: A way to link oracle DB to postgres DB for data transfer

Use JDBC - create a connection to each database and then copy data back and
forth from one connection to the other.

David
----- Original Message -----
From: <Zuhra(dot)Sanusi(at)seagate(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, October 24, 2002 4:42 PM
Subject: [GENERAL] A way to link oracle DB to postgres DB for data transfer

>
> I need to transfer data that reside in my oracle database to my
postgres
> database on a specific interval.
>
> So, is a way to create a link between the oracle DB and the postgres DB
> for data transfer usage.
>
> If I were to do it between 2 oracle database , I could have done via a
> DBLINK.
>
> I would greatly appreciate if someone could give me pointers on how to get
> this done.
>
> Thank you. Any help is greatly appreciated.
>
> Regards
> Zuhra Sanusi
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster