开发者

Postgresql analog to mysql federated table storage engine

开发者 https://www.devze.com 2023-03-21 06:15 出处:网络
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)

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 sa开发者_StackOverflow中文版me level of functionality as mysql's 'federated' storage engine (http://dev.mysql.com/doc/refman/5.0/en/federated-use.html).


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).


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

0

精彩评论

暂无评论...
验证码 换一张
取 消