将 mysql 连接到 postgresql
我正在使用 drupal 安装，它使用 mysql 创建一个新用户，必须创建他的电子邮件(其在 mysql 中的类型是 varchar(64))，然后转到实际网页，与 postgresql 一起使用，用户必须再次放置他的电子邮件然后保存.实际上，一旦他放入电子邮件(主键)，就会在 postgres 中创建新的用户表.
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).
我想要的是一个函数，或者是在 mysql 中创建新用户后，它会自动连接到 postgres 以将电子邮件保存在那里.是否可以?我该怎么做?
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?
推荐答案
您可能需要考虑外部数据包装器"(FDW).
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/静态/sql-createforeigndatawrapper.html
相关文章