3,765
回編集
差分
Tep3
,→ClientsをClientsとOthersに分ける
エクスポート
\COPY (select user_id, jiin_id, ie_id, name, yomi, nusi, each_order, table_order, generation, created_at, updated_at from clients where jiin_id = 1 order by ie_id asc) TO '/Users/jq/3tep_gomi/others_1.csv' WITH CSV DELIMITER ',' FORCE QUOTE * NULL AS '' HEADER;
...
</pre>
<pre>
インポート
\COPY others(user_id, note_id, client_id, name, yomi, nusi, line1, line2, generation, created_at, updated_at) FROM '/Users/jq/3tep_gomi/others_1.csv' WITH CSV DELIMITER ',';
...
</pre>