load_data.load

LOAD DATABASE
    FROM mysql://root@localhost/volunteers
    INTO postgresql://postgres:postgres@localhost:5432/postgres

WITH include drop, create tables, create indexes, reset sequences

SET work_mem to '256MB',
    maintenance_work_mem to '512 MB'

CAST type datetime to timestamp drop default drop not null,
     type date to date drop not null,
     type tinyint to smallint drop not null,
     type int to int drop not null,
     type bigint to bigint drop not null,
     type double to double precision drop not null,
     type float to real drop not null,
     type text to text drop not null,
     type varchar to varchar drop not null,
     type char to char drop not null,
     type blob to bytea drop not null,
     type longtext to text drop not null,
     type mediumtext to text drop not null,
     type tinytext to text drop not null,
     type longblob to bytea drop not null,
     type mediumblob to bytea drop not null,
     type tinyblob to bytea drop not null

BEFORE LOAD DO
    $$ CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; $$;