From: Joshua D. Drake <jd@commandprompt.com>
To: Martin_Hurst@dom.com
Cc: pgsql-interfaces@postgresql.org
Subject: Re: connecting to external database tables outside of
Date: Fri, 17 Oct 2003 12:51:08 -0700
Message-ID: <3F90482C.6050804@commandprompt.com> (raw)
In-Reply-To: <OF14CA3712.51DCB081-ON85256DC2.006B8E5D-85256DC2.006B82C6@pa.dominionnet.com>
References: <OF14CA3712.51DCB081-ON85256DC2.006B8E5D-85256DC2.006B82C6@pa.dominionnet.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jd@commandprompt.com, Martin_Hurst@dom.com
Subject: Re: connecting to external database tables outside of
In-Reply-To: <3F90482C.6050804@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox