mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-07 14:56:59 +02:00
19 lines
598 B
Fish
19 lines
598 B
Fish
LOAD DATABASE
|
|
FROM mysql://localhost:3306/dbname
|
|
INTO postgresql://localhost/db
|
|
|
|
WITH drop tables,
|
|
truncate,
|
|
create tables,
|
|
create indexes,
|
|
reset sequences,
|
|
downcase identifiers
|
|
|
|
SET guc_1 = 'value', guc_2 = 'other value'
|
|
|
|
CAST column col1 to timestamptz drop default using zero-dates-to-null,
|
|
type varchar to text,
|
|
type int with extra auto_increment to bigserial,
|
|
type datetime to timestamptz drop default using zero-dates-to-null,
|
|
type date drop not null drop default using zero-dates-to-null;
|