Skip site navigation (1) Skip section navigation (2)

Re: connecting to external database tables outside of

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Martin_Hurst(at)dom(dot)com
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: connecting to external database tables outside of
Date: 2003-10-17 19:51:08
Message-ID: 3F90482C.6050804@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
No. You would use middleware for that.

Martin_Hurst(at)dom(dot)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(at)commandprompt(dot)com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org



In response to

pgsql-interfaces by date

Next:From: Martin_HurstDate: 2003-10-17 19:56:47
Subject: Re: connecting to external database tables outside of the
Previous:From: Martin_HurstDate: 2003-10-17 19:35:41
Subject: connecting to external database tables outside of the postgres database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group