Here is someone looking for dblink with Oracle capability. It is not in
CVS yet, but we are trying to get it for 7.4. You might be able to run
/contrib/dblink from CVS in a few weeks without waiting for a 7.4 release.
---------------------------------------------------------------------------
Richard Huxton wrote:
> On Tuesday 08 Jul 2003 7:58 am, Shridhar Daithankar wrote:
> > On 8 Jul 2003 at 12:03, Madhavi Daroor wrote:
> > > Hi All,
> > >
> > > How do I link a postgres server and an Oracle server and get the data
> > > from an Oracle sever from a Postgres server? I'm using Postgres 7.2.3 on
> > > Red Hat linux 7.2
> > >
> > > Does postgres have any function to do so? And what other configuration
> > > changes are need to achieve this?
> >
> > Well no. There is nothing out of box that would help here.
>
> But I did see mention of a dblink for oracle a week or two ago. The dblink
> package is in contrib and I'd suggest a search of the archives for "dblink"
> and "oracle".
>
> --
> Richard Huxton
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073