pg_loader config to migrate a MySQL DB to Postgres

pgloader-commands

-- See https://github.com/dimitri/pgloader/blob/master/pgloader.1.md for 
-- connection string options.

LOAD DATABASE
    FROM mysql://root@localhost/mydb
    INTO postgresql:///mydb

WITH include drop, truncate, create tables, create indexes, foreign keys, reset sequences

-- CAST varchar to varchar instead of text
CAST type varchar to varchar;