CSVファイルをPostgreSQLã«å–り込む方法 | dTblog | デザインã¨ãƒ—ãƒã‚°ãƒ©ãƒ ã®å¢ƒç•Œã‚’ã•ã¾ã‚ˆã†ãƒ–ãƒã‚°
Excel ã§ä½œæˆã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ DB ã«å–り込むシーンã£ã¦ã€æ„外ã¨ã‚ã‚‹ã‚“ã ã‘ã©ã€ã“ã‚ŒãŒåŽ„介。 ãã†ã„ã†ã¨ã自分ã¯ã€Excel データを csv å½¢å¼ã§å‡ºåŠ›ã—ã¦ã‹ã‚‰ã€ãれを postgresql ã« COPY ã§å–り込むよã†ãªæµã‚Œã§ã‚„ã£ã¦ã‚‹ã‚“ã§ã™ãŒã€ COPY test FROM '/home/postgres/test.csv' WITH delimiter ',' null ''; ã“ã†ã„ã†é¢¨ã«ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ä¸ã«ã€Œ"aaa,bbb"ã€ã¿ãŸã„ãªé …ç›®ãŒã‚ã‚‹ã¨ã€ãã®ã‚«ãƒ³ãƒžã«ã‚‚åå¿œã—ã¡ã‚ƒã£ã¦ã‚«ãƒ©ãƒ ãŒåŒºåˆ‡ã‚‰ã‚Œã¦ã—ã¾ã†ã®ã§ã€ ERROR: extra data after last expected column ãªã‚“ã¦æ€’られã¦ã—ã¾ã†ã€‚ ã©ã†ã—ãŸã‚‚ã‚“ã‹ãªãƒ¼ã¨æ€ã£ã¦èª¿ã¹ã¦ã„ãŸã‚‰ã€ã„ã¤ã®é–“ã«ã‚„ら COPY 㯠CSV 対応ã—ã¦ã„る模様。 COPY test FROM '/home/postgres/te
PG Commander, a PostgreSQL client for Mac
Download Also available on the Mac App Store PG Commander requires OS X 10.8 or later. © 2013 Egger Apps e. U. PG Commander has been discontinued and is no longer supported. Please have a look at its successor Postico. PG Commander is a client for everyone working with PostgreSQL databases. Display tables and views in a gorgeous user interface. Filter Table Rows by searching all columns, or combin
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
http://www.programming-magic.com/20071222002506/
ã„ã¾ã•ã‚‰èžã‘ãªã„PostgreSQLé‹ç”¨ç®¡ç†
{{#tags}}- {{label}}
{{/tags}}