22 lines
606 B
Fish
22 lines
606 B
Fish
LOAD DATABASE
|
|
FROM mysql://root:HP_LE1851w@192.168.1.140/elearning
|
|
INTO postgresql://postgres:HP_LE1851w@192.168.1.140:5432/elearning
|
|
|
|
WITH include no drop,
|
|
create tables,
|
|
create indexes,
|
|
reset sequences
|
|
|
|
CAST
|
|
type tinyint when (= precision 1) to smallint drop typemod,
|
|
type smallint to smallint drop typemod,
|
|
type int to integer drop typemod,
|
|
type integer to integer drop typemod,
|
|
type datetime to timestamptz drop default drop not null,
|
|
type date to date
|
|
|
|
SET work_mem TO '16MB',
|
|
maintenance_work_mem TO '512MB',
|
|
search_path TO 'public'
|
|
;
|