Postgresql analog to mysql federated table storage engine

Question

Between DBLink in postgresql (http://www.postgresql.org/docs/current/static/dblink.html) and foreign data wrappers (http://www.postgresql.org/docs/9.1/static/ddl-foreign-data.html), which one (if any) provides the same level of functionality as mysql's 'federated' storage engine (http://dev.mysql.com/doc/refman/5.0/en/federated-use.html).

score 1 · Answer 1 · answered Jul 17 '11 at 06:50

If you make a side by side comparison (including limitations):

The db_link contrib offers mostly the same functionality, with a different syntax.

Foreign data wrappers offer roughly the same syntax, with an API that allows you to connect to anything (not just MySQL servers).

score 0 · Answer 2 · answered Jul 17 '11 at 20:19

0

plProxy is the closest thing to the federated engine. plProxy wiki page

answered Jul 17 '11 at 20:19

Scott Marlowe

8,490
3
23
21

Postgresql analog to mysql federated table storage engine

2 Answers2