View "View" from Postgres in Mysql. It's possible? How to make?

Question

View "View" from Postgres in Mysql. It's possible? How to make?

Navigation

#1 by (1 votes)
#2 by (1 votes)

5

Is there any way to view a View created in Postgres and view it in MySQL? If yes, how to configure?

mysql postgresql odbc

asked by anonymous 01.09.2014 / 20:26

2 answers

FireBase Google Pass base64 code to another page

score 1 · Answer 1

No, one bank can not access the other. What you can do is, build an application that will serve as a bridge between these two servers and use one dataset to feed one another with the view information in question.

score 1 · Answer 2

It seems like this is not possible. MySQL has an engine FEDERATED to connect to external banks. Unfortunately, the current version of MySQL (5.7) limits federated access to other MySQL databases ( link to the documentation ).

MariaDB , a MySQL fork has an engine CONNECT " able to access PostgreSQL through OBDC, but So far, as far as I know, this engine is not compatible with MySQL.

Font : SOen - Do databases besides Postgres have features comparable to foreign data wrappers?