pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedconnecting to external database tables outside of the postgres database
3+ messages / 2 participants
[nested] [flat]
* connecting to external database tables outside of the postgres database
@ 2003-10-17 19:35 Martin_Hurst@dom.com
2003-10-17 19:51 ` Re: connecting to external database tables outside of Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 3+ messages in thread
From: Martin_Hurst@dom.com @ 2003-10-17 19:35 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: connecting to external database tables outside of
2003-10-17 19:35 connecting to external database tables outside of the postgres database Martin_Hurst@dom.com
@ 2003-10-17 19:51 ` Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 3+ messages in thread
From: Joshua D. Drake @ 2003-10-17 19:51 UTC (permalink / raw)
To: Martin_Hurst@dom.com; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: connecting to external database tables outside of the
@ 2003-10-17 19:56 Martin_Hurst@dom.com
0 siblings, 0 replies; 3+ messages in thread
From: Martin_Hurst@dom.com @ 2003-10-17 19:56 UTC (permalink / raw)
To: jd@commandprompt.com; +Cc: Martin_Hurst@DOM.COM; pgsql-interfaces
Somebody from the pgsql-general@postgresql.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
it
does what you are looking for.
You didn't mention what your application was but, you might want to
consider
tools like Perl's DBI as well, which (within one script) can connect to
several
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??).
That
might open up some interesting functionalities :)
===========================
"Joshua D. Drake"
<jd@commandprompt To: Martin_Hurst@dom.com
.com> cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] connecting to external database tables outside of the
10/17/2003 03:51 postgres database
PM
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-10-17 19:56 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-10-17 19:35 connecting to external database tables outside of the postgres database Martin_Hurst@dom.com
2003-10-17 19:51 ` Re: connecting to external database tables outside of Joshua D. Drake <jd@commandprompt.com>
2003-10-17 19:56 Re: connecting to external database tables outside of the Martin_Hurst@dom.com
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