Re: connecting to external database tables outside of - Mailing list pgsql-interfaces

From Joshua D. Drake
Subject Re: connecting to external database tables outside of
Date
Msg-id 3F90482C.6050804@commandprompt.com
Whole thread Raw
In response to connecting to external database tables outside of the postgres database  (Martin_Hurst@dom.com)
List pgsql-interfaces
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




pgsql-interfaces by date:

Previous
From: Martin_Hurst@dom.com
Date:
Subject: Re: connecting to external database tables outside of the
Next
From: Andrew S Halper
Date:
Subject: EXEC SQL INCLUDE syntax