第3回 XPathã®å¿œç”¨ï¼PostgreSQLã®XPath機能を利用ã—ãŸãƒ‡ãƒ¼ã‚¿ç…§ä¼šã®å®Ÿéš› | Let's POSTGRESã“れをcsvå½¢å¼ã®ãƒ‡ãƒ¼ã‚¿ã¨ã™ã‚‹ã¨ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ï¼ˆï¼‘行分ã ã‘記ã—ã¾ã™ï¼‰ã€‚ 1076,石å·é †å,開発一課,23,[email protected],"<work-record> <career> <period> <start>2008-09-01</start> <end/> </period> <content>亀ãƒã‚¸ã‚¹ãƒ†ã‚£ã‚¯ã‚¹æ§˜ç¤¾å†…ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯é‹ç”¨ä¿å®ˆ</content> <role>é‹ç”¨ãƒ¡ãƒ³ãƒãƒ¼</role> </career> </work-record>" ã¨ã“ã‚ã§ã€ãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã®éš›ã€ã“ã‚Œã¾ã§ã¯INSERTæ–‡ã®ä¸ã«ç›´æŽ¥ãƒ‡ãƒ¼ã‚¿ã¨ãªã‚‹æ–‡å—列を埋ã‚込んã§ã„ã¾ã—ãŸãŒã€ä»Šå›žã¯æ•°ãŒå¤šã„ã®ã§ã€csvå½¢å¼ã§ç”¨æ„ã—ã¦ãŠã„ãŸãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ä¸€æ‹¬æŒ¿å…¥ã§ãã‚‹COPYコマンドを使ã£ã¦ã¿ã¾ã—ょã†ã€‚ã“ã“ã§èªã¿è¾¼ã‚€ãƒ•ã‚¡ã‚¤ãƒ«ã¯PostgreSQLデータベースã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã‚¢ã‚¯ã‚»ã‚¹è¨±å¯ã•ã‚Œã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚Win
{{#tags}}- {{label}}
{{/tags}}