If you 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, lesser-known FDWs, the mysql_fdw extension is actually quite powerful and offers the following features:
- Writing to MySQL/MariaDB
- Connection pooling
- The WHERE clause push down (which means that filters applied on a table can actually be executed ...