Postgres Pro
Downloads
Home   >   mailing lists

Re: How to connect to an oracle table from Postgres? - Mailing list pgsql-admin

From Jonah H. Harris
Subject Re: How to connect to an oracle table from Postgres?
Date
Msg-id 36e682920606060907y46327be9v172229809b1bfe44@mail.gmail.com
Whole thread Raw
In response to How to connect to an oracle table from Postgres?  ("" <dba@ciberforce.net>)
List pgsql-admin
Tree view 
On 6/6/06, dba@ciberforce.net <dba@ciberforce.net> wrote:
> I want to be able to read an oracle tabe from within Postgres. The Oracle db is on a different server within the same
network.Is there a good way to pull this off? 

Your only option with native PostgreSQL is to use dbi-link.  Not to
explicitly plug EnterpriseDB here, but we have a native OCI-based
connector for PostgreSQL which is quite a bit faster than dbi-link if
speed is what you need.

dbi-link:
http://pgfoundry.org/projects/dbi-link/

EnterpriseDB Release 2 Beta 3:
http://www.enterprisedb.com/products/download.do

--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 2nd Floor            | jharris@enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/

pgsql-admin by date:

Previous
From: ""
Date:
Subject: How to connect to an oracle table from Postgres?
Next
From: "Jonah H. Harris"
Date:
Subject: Re: oralink documentation