Mastering PostgreSQL 12 - Third Edition

Using FDWs

If we want to move from MySQL/MariaDB to PostgreSQL, there is more than one way to succeed. The use of FDWs is an alternative to pg_chameleon and offers a way to quickly fetch the schema, as well as the data, and import it into PostgreSQL. The ability to connect MySQL and PostgreSQL has been around for quite a while, and therefore FDWs are definitely a field that can be exploited to your advantage.

Basically, the mysql_fdw extension works just like any other FDW out there. Compared to other, less well-known FDWs, the mysql_fdw extension is actually quite powerful and offers the following features:

• Writing to MySQL/MariaDB
• Connection pooling
• The WHERE clause pushdown (which means that filters that are applied on a table can actually ...