svU3AdCa

1LOAD DATABASE  
2     FROM      mysql://root:root@localhost/siis
3     INTO postgresql://postgres:postgres@localhost/siis_prodhim
4 
5 WITH include drop, create tables, create indexes, reset sequences, foreign keys, preserve index names
6 
7 SET maintenance_work_mem to '128MB',  
8     work_mem to '12MB',  
9     search_path to 'public'  
10 
11 CAST type datetime to timestamptz drop default drop not null using zero-dates-to-null,  
12      type date drop not null drop default using zero-dates-to-null, 
13      type timestamp to timestamptz drop default drop not null using zero-dates-to-null,
14      -- column care_address_citytown.is_village to siis.care_address_citytown_is_village,
15      -- column care_billing_bill_item.bill_item_status to siis.care_billing_bill_item_bill_item_status,
16      type tinyint to int drop typemod
17      -- type tinyint to boolean using tinyint-to-boolean,  
18      -- type year to integer  
19 
20 -- MATERIALIZE VIEWS data_history_changes, medicament_chart  
21MATERIALIZE ALL VIEWS
22 
23 -- INCLUDING ONLY TABLE NAMES MATCHING ~/film/, 'actor'  
24 -- EXCLUDING TABLE NAMES MATCHING ~<ory>  
25 -- DECODING TABLE NAMES MATCHING ~/messed/, ~/encoding/ AS utf8  
26 
27BEFORE LOAD DO
28$$ CREATE SCHEMA IF NOT EXISTS public; $$
29-- $$ DROP TYPE IF EXISTS siis.care_address_citytown_is_village CASCADE; $$,
30-- $$ CREATE TYPE siis.care_address_citytown_is_village AS ENUM('0','1'); $$,
31-- $$ DROP TYPE IF EXISTS siis.care_billing_bill_item_bill_item_status CASCADE; $$,
32-- $$ CREATE TYPE siis.care_billing_bill_item_bill_item_status AS ENUM ('0', '1'); $$;
33;
34
35-- pgloader-master/build/bin/pgloader  pgloader.load