mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-07 14:56:59 +02:00
19 lines
561 B
Fish
19 lines
561 B
Fish
LOAD DATABASE
|
|
FROM mysql://root@localhost/db789
|
|
INTO postgres:///pgloader
|
|
|
|
WITH data only, truncate, create no tables
|
|
|
|
MATERIALIZE VIEWS proceed, foo as $$ select 1 as a; $$
|
|
|
|
INCLUDING ONLY TABLE NAMES MATCHING 'proceed'
|
|
|
|
BEFORE LOAD DO
|
|
$$ drop schema if exists matview cascade; $$,
|
|
$$ drop schema if exists db789 cascade; $$,
|
|
$$ create schema db789; $$,
|
|
$$ create table db789.refrain (id char(1) primary key); $$,
|
|
$$ create table db789.proceed (id char(1) primary key); $$,
|
|
$$ create table db789.foo (a integer primary key); $$;
|
|
|