{"id":1813,"date":"2022-04-26T19:37:42","date_gmt":"2022-04-26T10:37:42","guid":{"rendered":"https:\/\/www.kwonline.org\/memo2\/?p=1813"},"modified":"2022-04-26T19:40:37","modified_gmt":"2022-04-26T10:40:37","slug":"bash-to-load-csv-to-postgres","status":"publish","type":"post","link":"https:\/\/www.kwonline.org\/memo2\/2022\/04\/26\/bash-to-load-csv-to-postgres\/","title":{"rendered":"PostgreSQL \u3067 CSV \u3092 bash \u3067\u30ed\u30fc\u30c9\u3059\u308b"},"content":{"rendered":"<p>&nbsp;<br \/>\n\u6bce\u56de\u5fd8\u308c\u3066\u30b0\u30b0\u308b\u306e\u3067\u30e1\u30e2\u3002<\/p>\n<p>\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u3067\u5024\u304c\u56f2\u307e\u308c\u305f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u5074\u306eCSV\u3092\u30ed\u30fc\u30c9\u3059\u308b\u3002<br \/>\n\u306a\u304a 1 \u884c\u76ee\u306f\u30d8\u30c3\u30c0\u30fc\u306a\u306e\u3067\u30b9\u30ad\u30c3\u30d7\u3002<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\n$ psql -h hoge.rds.amazonaws.com -d mydatabase -U myuser \\\r\n-c &quot;\\copy schema.table01 from 'data01.csv' delimiter ',' quote '\\&quot;' header csv;&quot;\r\n<\/pre>\n<p>&nbsp;<br \/>\n\u7279\u5b9a\u306e\u30ab\u30e9\u30e0\u3060\u3051\u30ed\u30fc\u30c9\u3059\u308b\u306a\u3089\u3053\u3046\u3002<br \/>\nSequence\u3067ID\u3092\u81ea\u52d5\u4ed8\u4e0e\u3059\u308b\u30ab\u30e9\u30e0\u304c\u3042\u308b\u5834\u5408\u306a\u3069\u306b\u4f7f\u3046\u3002<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\n$ psql -h hoge.rds.amazonaws.com -d mydatabase -U myuser \\\r\n-c &quot;\\copy schema.table01(col2, col4, col5) from 'data_part01.csv' delimiter ',' quote '\\&quot;' header csv;&quot;\r\n<\/pre>\n<p>&nbsp;<br \/>\n\u3044\u305a\u308c\u3082\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u5074\u306b\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308b\u524d\u63d0\u3002<br \/>\nAWS RDS \u3060\u3068OS\u306b\u30a2\u30af\u30bb\u30b9\u51fa\u6765\u306a\u3044\u3057\u3002<br \/>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; \u6bce\u56de\u5fd8\u308c\u3066\u30b0\u30b0\u308b\u306e\u3067\u30e1\u30e2\u3002 \u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u3067\u5024\u304c\u56f2\u307e\u308c\u305f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u5074\u306eCSV\u3092\u30ed\u30fc\u30c9\u3059\u308b\u3002 \u306a\u304a 1 \u884c\u76ee\u306f\u30d8\u30c3\u30c0\u30fc\u306a\u306e\u3067\u30b9\u30ad\u30c3\u30d7\u3002 $ psql -h hoge.rds.amazonaws.com -d [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,26,20],"tags":[],"class_list":["post-1813","post","type-post","status-publish","format-standard","hentry","category-linux","category-postgresql","category-sql"],"_links":{"self":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/comments?post=1813"}],"version-history":[{"count":9,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1813\/revisions"}],"predecessor-version":[{"id":1823,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1813\/revisions\/1823"}],"wp:attachment":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/media?parent=1813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/categories?post=1813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/tags?post=1813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}