tombeynon
10/5/2016 - 3:06 PM

pg_loader config to migrate a MySQL DB to Postgres

pg_loader config to migrate a MySQL DB to Postgres

-- 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;