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
