3,765
回編集
差分
→postgres
<nowiki>=# COPY (SELECT userid,jiinid,ie_id,name,yomi,nusi,each_order,memo,generation,created_at,updated_at FROM jq_clients WHERE jiin_id = 1) TO '/Users/jq/rails_app_tepnote/jq_clients.csv' WITH CSV HEADER;
COPY 3066</nowiki>
=== 指定行を作る ===
<nowiki>=# INSERT INTO others (user_id, note_id, client_id, created_at, updated_at)
SELECT
'44f47a1e-2ccf-4213-bac5-aa62c5f3c141', 'd23ae9b5-5a74-4e95-9933-0e710b13401a', '6d7d3f62-ebc8-4de1-bc46-06287a19d8d1', '2022-09-12 19:11:46.986872', '2022-09-12 19:11:46.986872'
FROM
generate_series(1,3066) ;
INSERT 0 3066
</nowiki>
== ローカル ==