X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8CBC19FA6B1 for ; Tue, 6 Jun 2006 13:07:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 21941-06 for ; Tue, 6 Jun 2006 13:07:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 689189FA6B0 for ; Tue, 6 Jun 2006 13:07:19 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so1767539ugf for ; Tue, 06 Jun 2006 09:07:17 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=dCMhIxmCvcoZK/sQhus2GwEBKp2EkDAICcmtHCAmZXTrkK4QHWWyqbOE1wQ9A52tcAzCfRJCKjkA5UQPlrHY+d+l3r/+dDxczC4Fpx+dX8ghGcixIsEcvBKWk0B/feQkC+KFWzlvEtMaWaAMXT2u1rT20lMviuFRh9qN3v/rF2E= Received: by 10.66.250.17 with SMTP id x17mr4647101ugh; Tue, 06 Jun 2006 09:07:17 -0700 (PDT) Received: by 10.67.97.11 with HTTP; Tue, 6 Jun 2006 09:07:17 -0700 (PDT) Message-ID: <36e682920606060907y46327be9v172229809b1bfe44@mail.gmail.com> Date: Tue, 6 Jun 2006 12:07:17 -0400 From: "Jonah H. Harris" To: dba@ciberforce.net Subject: Re: How to connect to an oracle table from Postgres? Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/30 X-Sequence-Number: 21992 On 6/6/06, 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/