Multiline table migration migration on windows cmd for PostgreSQL
Tables matches
psql -U USERNAME -h localhost -d DATABASE ^
-c "copy (SELECT * FROM customer_modules) to stdout with csv" | ^
psql -U USERNAME -h localhost -p 5433 -d DATABASE ^
-c "copy customer_modules from stdin csv"
Tables columns doesnt match
psql -U USERNAME -h localhost -d DATABASE ^
-c "copy (SELECT * FROM assignments WHERE id_over_slot_price_rate !=1) to stdout with csv" | ^
psql -U USERNAME -h localhost -p 5433 -d DATABASE ^
-c "copy assignments (id_assignment, id_ltc_group, id_component, slots, deleted, id_std_price_rate, id_over_slot_price_rate, discount, id_customer, id_users_log) from stdin csv"