X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3B9ACD1B554 for ; Fri, 17 Oct 2003 19:53:39 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 10267-02 for ; Fri, 17 Oct 2003 16:53:09 -0300 (ADT) Received: from hosting.commandprompt.com (222.commandprompt.com [207.173.200.222]) by svr1.postgresql.org (Postfix) with ESMTP id 0D8E8D1B573 for ; Fri, 17 Oct 2003 16:52:38 -0300 (ADT) Received: from commandprompt.com (dsl093-077-251.sea2.dsl.speakeasy.net [66.93.77.251]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id h9HJqau15041; Fri, 17 Oct 2003 12:52:36 -0700 Message-ID: <3F90482C.6050804@commandprompt.com> Date: Fri, 17 Oct 2003 12:51:08 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030807 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Martin_Hurst@dom.com Cc: pgsql-interfaces@postgresql.org Subject: Re: connecting to external database tables outside of References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/37 X-Sequence-Number: 4526 No. You would use middleware for that. Martin_Hurst@dom.com wrote: >Is it possible to establish a connection from within a postgres database to >another external database on the network, i.e., not a java or scripting >connection, BUT by some type of table definition within the postgres >database of that external database table source - something similar to a >proxy definition. >Examples of external database could be MSAccess, Oracle, Sybase, >MSQLServer, etc. > >The idea behind this would to be able to at least look up data from other >database sources. > >At the very most to be able to actually access data in other database table >sources and perform insert, update, delete, transaction on that external >database tables rows and columns. > >-Martin > > > > >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings > > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org