knex: Migrate from MySQL to PostgreSQL

mysql-to-postgres.ts

const pg = require('pg');
pg.defaults.ssl = true;
const configs = require("config/knexfile.js");

const mysql = require("knex")(configs["mysql"]);
const postgres = require("knex")(configs["postgres"]);

async function migrate(table) {
  const results = await mysql.from(table);
  await postgres(table).insert(results);
}

(async () => {
  await migrate("users");
  await migrate("entries");
  await migrate("tags");
  await migrate("entry_to_tag");
})().catch(err => {
  console.error(err);
  process.exit(1);
});

This don't working