1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
LOAD DATABASE
FROM mysql://root@localhost:3306/exhausted
INTO postgresql:///exhausted
WITH include drop, create tables, create indexes, reset sequences, truncate
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 timestamp to timestamptz drop not null using zero-dates-to-null,
-- now the default for tinyint(1)
-- column bools.a to boolean drop typemod using tinyint-to-boolean,
-- override char(1) to varchar(1), just use char(1) here.
type char when (= precision 1) to char keep typemod;
|
