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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match