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 400BD9FA43C for ; Tue, 6 Jun 2006 12:50:24 -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 21833-02 for ; Tue, 6 Jun 2006 12:50:20 -0300 (ADT) X-Greylist: delayed 00:16:54.325575 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 6B92F9F9316 for ; Tue, 6 Jun 2006 12:50:21 -0300 (ADT) X-Greylist: delayed 1159 by SQLgrey-1.7.3 Received: from mailout10.yourhostingaccount.com (outmail80.yourhostingaccount.com [65.254.253.80]) by svr4.postgresql.org (Postfix) with ESMTP id 4269E5AF02B for ; Tue, 6 Jun 2006 15:33:25 +0000 (GMT) Received: from scan21.yourhostingaccount.com ([10.1.1.224] helo=scan21.yourhostingaccount.com) by mailout10.yourhostingaccount.com with esmtp (Exim) id 1FndFr-00070A-TE for pgsql-admin@postgresql.org; Tue, 06 Jun 2006 11:14:04 -0400 Received: from webmail10.yourhostingaccount.com ([10.1.16.10] ident=exim) by scan21.yourhostingaccount.com with spamscanlookuphost (Exim) id 1FndFr-0005fn-Cx for pgsql-admin@postgresql.org; Tue, 06 Jun 2006 11:14:03 -0400 Received: from webmail10.yourhostingaccount.com ([10.1.16.10] helo=webmail10.yourhostingaccount.com) by scan21.yourhostingaccount.com with esmtp (Exim) id 1FndFp-0005fN-Vi for pgsql-admin@postgresql.org; Tue, 06 Jun 2006 11:14:02 -0400 Received: from nobody by webmail10.yourhostingaccount.com with local (Exim) id 1FndFc-0001gF-C6 for pgsql-admin@postgresql.org; Tue, 06 Jun 2006 11:13:48 -0400 Content-Disposition: inline Content-Transfer-Encoding: binary Mime-Version: 1.0 From: "" To: pgsql-admin@postgresql.org Subject: How to connect to an oracle table from Postgres? Reply-To: dba@ciberforce.net Content-Type: text/plain X-Mailer: AtMail Corp 3.64 - http://webbasedemail.com/ X-Origin: 63.214.184.6 Message-Id: Date: Tue, 06 Jun 2006 11:13:48 -0400 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.826 tagged_above=0 required=5 tests=BAYES_40, DNS_FROM_RFC_WHOIS, FROM_BLANK_NAME, NO_REAL_NAME, SPF_NEUTRAL X-Spam-Level: **** X-Archive-Number: 200606/29 X-Sequence-Number: 21991 Hi List; 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? Thanks. -joe