3,765
回編集
差分
Tep3
,→エクスポート
== データベース移行 ==
=== エクスポート ===
\COPY (select ie_id, user_id, jiin_id, created_at, updated_at from clients where nusi = true order by jiin_id asc, ie_id asc) TO '/Users/jq/3tep_gomi/clients.csv' WITH CSV DELIMITER ',' FORCE QUOTE * NULL AS '' HEADER;
\COPY (select user_id, jiin_id, ie_id, name, yomi, nusi, each_order, table_order, generation, created_at, updated_at from clients order by jiin_id asc, ie_id asc) TO '/Users/jq/3tep_gomi/others.csv' WITH CSV DELIMITER ',' FORCE QUOTE * NULL AS '' HEADER;
=== インポート ===
\COPY notes(user_id, name, kind, meeting_time, role, created_at, updated_at) FROM '/Users/jq/3tep_gomi/notes.csv' WITH CSV DELIMITER ',';
\COPY others(user_id, note_id, client_id, name, yomi, nusi, order1, order2, generation, created_at, updated_at) FROM '/Users/jq/3tep_gomi/others.csv' WITH CSV DELIMITER ',';