Re: LinkServer

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: shridhar_daithankar(at)persistent(dot)co(dot)in, pgsql-general(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LinkServer
Date: 2003-07-21 16:45:40
Message-ID: 200307211645.h6LGje420194@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Gamache 2003-07-21 17:05:40 pg_dump dies on a renamed sequence... (7.2)
Previous Message Kathy Zhu 2003-07-21 16:10:48 Re: Incomprehensible behaviour of a foreign key.

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-07-21 19:04:15 Re: Why are triggers semi-deferred?
Previous Message Hans-Jürgen Schönig 2003-07-21 16:15:14 Re: dblink_ora - a first shot on Oracle ...