3,765
回編集
差分
Tep3
,→Client_categories
==== Client_categories ====
* 新Clientsからidのみ抜き出す
<pre>
エクスポート
\COPY (select properties.user_id, properties.jiin_id, properties.client_id, properties.category_id, properties.created_at, properties.updated_at from properties join categories on properties.category_id = categories.id where properties.jiin_id = 1 and categories.set_id = 2) TO '/Users/jq/3tep_gomi/client_category_1_1.csv' WITH CSV DELIMITER ',' FORCE QUOTE * NULL AS '' HEADER;
...
</pre>
<pre>