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