how to access postgres from mysql?

Question

Is it possible to access a Postgres database from MySQL, so that I could run a single query that does joins across tables in both databases?

For example:

SELECT * FROM postgres.db1.table1 as t1, mysql.db2,table2 WHERE t1.id=t2.id;

Kouber Saparev · Accepted Answer · 2014-10-15 14:38:09Z

4

According to the MySQL CREATE SERVER documentation:

The wrapper_name should be mysql, and may be quoted with single quotation marks. Other values for wrapper_name are not currently supported.

So the answer is no, you cannot do that at the moment, but you can access the MySQL server from within PostgreSQL instead.

answered Oct 15, 2014 at 14:38

Kouber Saparev

8,2552 gold badges32 silver badges28 bronze badges

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

1 Comment

Craig Ringer Over a year ago

If you use mysql_fdw in PostgreSQL it'll work, but probably perform pretty poorly as it's quite limited in how it executes cross-server joins using FDWs.

Collectives™ on Stack Overflow

how to access postgres from mysql?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related