「Heroku」の版間の差分
提供: wikipokpok
5行目: | 5行目: | ||
idで名前と戒名を紐付ける | idで名前と戒名を紐付ける | ||
heroku pg:psql -c "\copy clients (id,name,yomi,ie_id,nusi,user_id,jiin_id,created_at,updated_at,ie_id_v) from '/home/shudo/an_meibo.csv' with csv" | heroku pg:psql -c "\copy clients (id,name,yomi,ie_id,nusi,user_id,jiin_id,created_at,updated_at,ie_id_v) from '/home/shudo/an_meibo.csv' with csv" | ||
+ | |||
+ | heroku pg:psql -c "\copy kaimyous (content,user_id,jiin_id,client_id,created_at,updated_at,date,ie_id,g_age,relationship,ie_id_v) from '/home/shudo/an_meibo.csv' with csv" |
2019年2月2日 (土) 10:31時点における版
heroku pg:psql -c "\d clients"
heroku pg:psql -c "select * from clients_id_seq"
idで名前と戒名を紐付ける
heroku pg:psql -c "\copy clients (id,name,yomi,ie_id,nusi,user_id,jiin_id,created_at,updated_at,ie_id_v) from '/home/shudo/an_meibo.csv' with csv"
heroku pg:psql -c "\copy kaimyous (content,user_id,jiin_id,client_id,created_at,updated_at,date,ie_id,g_age,relationship,ie_id_v) from '/home/shudo/an_meibo.csv' with csv"