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

I don't know about DB specific.. and their might be a better way.. but
couldn't you just dump the data to file in a specific format/order and
cp to wherever postgres is running and have a script that reads it back
in?

Travis

-----Original Message-----
From: Zuhra(dot)Sanusi(at)seagate(dot)com [mailto:Zuhra(dot)Sanusi(at)seagate(dot)com]
Sent: Thursday, October 24, 2002 6:43 PM
To: pgsql-general(at)postgresql(dot)org
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