0

I'm trying migrate my DB from maria DB to PGSQL.

I have a script file

LOAD DATABASE
FROM mysql://user:pass@server/mysql-db
INTO postgresql://user:pass@server:port/pg-db;

After running I'm getting some log and error:

2019-02-10T12:50:58.837000Z INFO CREATE TABLE ao_e8b6cc_git_hub_event
(
  created_at             timestamptz not null,
  git_hub_id             text not null default ''0'',
  id                     bigserial not null,
  repository_id          bigint not null,
  save_point             boolean default NULL
);

In mysql DB I have a table ao_e8b6cc_git_hub_event

This table contains column git_hub_id STRING with default value 0

I think problem in text not null default ''0''

pgloader makes two single quotes. How I can fix it?

0 Answers0