connect mysql to postgresql

Question

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?

kgrittn · Accepted Answer · 2012-04-26 12:31:36Z

3

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

answered Apr 26, 2012 at 12:31

kgrittn

19.8k4 gold badges41 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

connect mysql to postgresql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related