connecting to external database tables outside of the postgres database

From: Martin_Hurst(at)dom(dot)com
To: pgsql-interfaces(at)postgresql(dot)org
Subject: connecting to external database tables outside of the postgres database
Date: 2003-10-17 19:35:41
Message-ID: OF14CA3712.51DCB081-ON85256DC2.006B8E5D-85256DC2.006B82C6@pa.dominionnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Joshua D. Drake 2003-10-17 19:51:08 Re: connecting to external database tables outside of
Previous Message Nairn, Bruce 2003-10-15 14:48:09 Help - psql/libpq under mswin