pgloader: Migrating a table from MySQL/MariaDB to PostgreSQL
pgloader is a helpful tool if you want to migrate tables from MySQL/MariaDB to Postgres. This works with AWS RDS instances too.
Let’s say we need to migrate the
user table from MySQL to PostgreSQL. Your
pgloader file would look like below.
You can use the below command to start the migration
$ pgload user.load