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.
