差分

  $ heroku pg:psql => INSERT INTO holidays (holiday, title, created_at, updated_at) VALUES ('2021-1-1','元日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-1-11', '成人の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-2-11', '建国記念の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-2-23', '天皇誕生日', '2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-3-20', '春分の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-4-29', '昭和の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-5-3', '憲法記念日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-5-4', 'みどりの日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-5-5', 'こどもの日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-7-22', '海の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-7-23', 'スポーツの日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-8-8', '山の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-8-9', '休日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-9-20', '敬老の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-9-23', '秋分の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-11-3', '文化の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2021-11-23','勤労感謝の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-1-1', '元日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-1-10', '成人の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-2-11', '建国記念の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-2-23', '天皇誕生日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-3-21', '春分の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-4-29', '昭和の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-5-3', '憲法記念日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-5-4', 'みどりの日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-5-5', 'こどもの日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-7-18', '海の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-8-11', '山の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-9-19', '敬老の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-9-23', '秋分の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-10-10','スポーツの日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-11-3', '文化の日','2021-06-15 18:46:45','2021-06-15 18:46:45'), ('2022-11-23','勤労感謝の日','2021-06-15 18:46:45','2021-06-15 18:46:45'); == ローカルのテーブルをCSV（タブ区切り）で書き出しHEROKUのテーブルにコピーする ローカルのテーブルをCSVで書き出しHEROKUのテーブルにコピーする == =# COPY accounts descriptions(content,user_id,jiin_id,account_id,created_at,updated_at,money) TO '/Users/jq/environment/table_data/accountsdescriptions.csv' WITH CSV DELIMITER E;  heroku pg:psql -c "select setval ('\tdescriptions_id_seq';, 1, false)"　　　←シーケンスのリセット  % heroku pg:psql -c "\COPY accountsdescriptions(account_cdcontent,accountuser_id,bs_pljiin_id,debit_creditaccount_id,created_at,updated_at,money) FROM '/Users/jq/environment/table_data/accountsdescriptions.csv'"