Monday, 15 April 2013

postgresql - how to access postgres from mysql? -



postgresql - how to access postgres from mysql? -

is possible access postgres database mysql, run single query joins across tables in both databases?

for example:

select * postgres.db1.table1 t1, mysql.db2,table2 t1.id=t2.id;

according mysql create server documentation:

the wrapper_name should mysql, , may quoted single quotation marks. other values wrapper_name not supported.

so reply no, cannot @ moment, can access mysql server within postgresql instead.

mysql postgresql federated

No comments:

Post a Comment