pgloader example

gistfile1.sql

LOAD DATABASE
     FROM      mysql://root@localhost/sakila
     INTO postgresql://localhost:54393/sakila

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

  SET maintenance_work_mem to '128MB', work_mem to '12MB',
      search_path to 'sakila' /* migrate to a specific schema */

 CAST type datetime to timestamptz
           drop default drop not null using zero-dates-to-null,
      type date drop not null drop default using zero-dates-to-null,
      type year to integer

 BEFORE LOAD DO
      $$ create schema if not exists sakila; $$;

Thx for this, pgloader is so poorly documented.

Nothing helps like a good set of examples.