Thread: opening a channel between two postgreSQL-servers?
Hi. a handy thing in mysql is FEDERATED tables that allows one to open a channel from one MySQL-server to another MySQL-server. it helps a lot when writing stored procedures that transfer data to other servers. you can do the transfer without any extarnal temporary files or external applications that read from one server and insert into another server. Does PG have anything similar? if yes, which chapter in the docs for 8.1 will tell me more? no wars please. i just want to know if such a possibility exists in PG. /stig
On Sat, Nov 04, 2006 at 10:12:00PM +0100, stig erikson wrote: > a handy thing in mysql is FEDERATED tables that allows one to open a > channel from one MySQL-server to another MySQL-server. > it helps a lot when writing stored procedures that transfer data to other > servers. you can do the transfer without > any extarnal temporary files or external applications that read from one > server and insert into another server. > > Does PG have anything similar? Not in the stock installation but you can establish a connection between one PostgreSQL server and another with contrib/dblink, or with just about any other data source using David Fetter's dbi-link. http://pgfoundry.org/projects/dbi-link/ PostgreSQL has several server-side languages such as PL/Perl, PL/Python, PL/Tcl, PL/Ruby, PL/php, PL/Java, PL/R, etc. In general a server-side function written in one of those languages can do anything a standalone application could do, such as connecting to another database, even a different DBMS (you could connect from PostgreSQL to MySQL, Oracle, SQL Server, etc.). -- Michael Fuhr
I believe contrib/dblink may be what you're after... On Sat, 4 Nov 2006, stig erikson wrote: > Hi. > a handy thing in mysql is FEDERATED tables that allows one to open a channel > from one MySQL-server to another MySQL-server. > it helps a lot when writing stored procedures that transfer data to other > servers. you can do the transfer without > any extarnal temporary files or external applications that read from one > server and insert into another server. > > Does PG have anything similar? > if yes, which chapter in the docs for 8.1 will tell me more? > no wars please. i just want to know if such a possibility exists in PG. > > /stig > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >
Michael Fuhr wrote: > On Sat, Nov 04, 2006 at 10:12:00PM +0100, stig erikson wrote: >> a handy thing in mysql is FEDERATED tables that allows one to open a >> channel from one MySQL-server to another MySQL-server. >> it helps a lot when writing stored procedures that transfer data to other >> servers. you can do the transfer without >> any extarnal temporary files or external applications that read from one >> server and insert into another server. >> >> Does PG have anything similar? > > Not in the stock installation but you can establish a connection > between one PostgreSQL server and another with contrib/dblink, or > with just about any other data source using David Fetter's dbi-link. > > http://pgfoundry.org/projects/dbi-link/ > > PostgreSQL has several server-side languages such as PL/Perl, > PL/Python, PL/Tcl, PL/Ruby, PL/php, PL/Java, PL/R, etc. In general > a server-side function written in one of those languages can do > anything a standalone application could do, such as connecting to > another database, even a different DBMS (you could connect from > PostgreSQL to MySQL, Oracle, SQL Server, etc.). > thank you Michel and Ben.