On 6/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 | [EMAIL PROTECTED] Iselin, New Jersey 08830 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
