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
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. |
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 ... |