Somebody from the pgsql-general(at)postgresql(dot)org list, mentioned using
"dblink" to possibly do what I'm looking for.
Check out "dblink" in the contrib path of the source distribution, I think
does what you are looking for.
You didn't mention what your application was but, you might want to
tools like Perl's DBI as well, which (within one script) can connect to
DB's. Of course that method is NOT within the database...
.it would be nice if pl/perl could use modules (can it use modules??).
might open up some interesting functionalities :)
"Joshua D. Drake"
<jd(at)commandprompt To: Martin_Hurst(at)dom(dot)com
.com> cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] connecting to external database tables outside of the
10/17/2003 03:51 postgres database
No. You would use middleware for that.
>Is it possible to establish a connection from within a postgres database
>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
>Examples of external database could be MSAccess, Oracle, Sybase,
>The idea behind this would to be able to at least look up data from other
>At the very most to be able to actually access data in other database
>sources and perform insert, update, delete, transaction on that external
>database tables rows and columns.
>---------------------------(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
pgsql-interfaces by date
|Next:||From: Andrew S Halper||Date: 2003-10-17 22:42:20|
|Subject: EXEC SQL INCLUDE syntax|
|Previous:||From: Joshua D. Drake||Date: 2003-10-17 19:51:08|
|Subject: Re: connecting to external database tables outside of|