将mysql连接到postgresql [英] connect mysql to postgresql

问题描述

我正在使用一个drupal安装，它使用mysql来创建一个新的用户，必须把他的电子邮件创建（它的类型在mysql中是varchar（64）），然后去实际的网页，这与postgresql一起使用，用户必须再次将电子邮件再次保存。实际上，一旦他放置电子邮件（主键），就会在postgres中创建新的用户表。

我想要的是一个功能，新用户在mysql中创建，它会自动连接到postgres，以保存电子邮件。可能吗？我可以这样做吗？

解决方案

你可能想考虑一个外部数据包装器（FDW）。

http://wiki.postgresql.org/wiki/ Foreign_data_wrappers＃mysql_fdw

http://www.postgresql.org/docs/9.1/static/sql-createforeigndatawrapper.html

i'm working with a drupal installation, that uses mysql to create a new user, that has to put his email to be created (its type in mysql is varchar(64)), and then goes to the actual webpage, that works with postgresql, and the user has to put his email another time and then save. Actually the new user table is created in postgres as soon as he puts the email (primary key).

what i would like is a function, or something that as soon as the new user is created in mysql, it automatically connects to postgres to save the email there. Is it possible? How can i do that?

解决方案

You might want to consider a "foreign data wrapper" (FDW).

http://wiki.postgresql.org/wiki/Foreign_data_wrappers#mysql_fdw

http://www.postgresql.org/docs/9.1/static/sql-createforeigndatawrapper.html

这篇关于将mysql连接到postgresql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！