PGLoader from Mysql To Public Schema Fixing TimeStamp columns

01_pg_load.sh

# Load data from mysql to postgres
$ pgloader mysql://username:password@localhost/dbname pgsql:///dbname

02_fix_schema.sql

-- Fix the schema
DROP SCHEMA public;
ALTER SCHEMA old_schema RENAME TO public;

03_fix_timestamps.sql

-- Run the output to fix timeStamp columns
SELECT CONCAT('ALTER TABLE ', table_name, ' ALTER ', column_name ,' SET DATA TYPE timestamp(0) without time zone;')
FROM  information_schema.columns
WHERE TABLE_SCHEMA='public'
      AND TABLE_CATALOG='old_schema'
      AND DATA_TYPE like 'timestamp%';