PostgreSQL 9.3ã®æ–°æ©Ÿèƒ½: æ›´æ–°å¯èƒ½VIEW | Let's POSTGRESSRA OSS, Inc. 日本支社 石井 é”夫 ç¾åœ¨é–‹ç™ºä¸ã®PostgreSQL 9.3ã§ã™ãŒã€å¾ã€…ã«æ–°æ©Ÿèƒ½ãŒå‡ºæƒã£ã¦ãã¾ã—ãŸã€‚ãã®ä¸ã®ä¸€ã¤ã«ã€Œæ›´æ–°å¯èƒ½VIEWã€("Updatable view")ã¨ã„ã†ã®ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯ãã®åã®é€šã‚Šã€æ›´æ–°å¯èƒ½ãªVIEWを作る機能ã§ã™ã€‚ VIEWã¨ã¯ï¼Ÿ VIEWã¨ã¯ã€å®Ÿéš›ã«ã¯å˜åœ¨ã—ãªã„テーブルã®ã“ã¨ã§ã€CREATE VIEWã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ã‚’使ã£ã¦å®šç¾©ã—ã¾ã™ã€‚VIEWã¯ä¸€ç¨®ã®ãƒžã‚¯ãƒã¨è€ƒãˆã‚‹ã“ã¨ãŒã§ãã€ã‚ˆã使ã†SELECT文をVIEWã¨ã—ã¦å®šç¾©ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€è¤‡é›‘ãªSELECT文を毎回打ã¡è¾¼ã‚€æ‰‹é–“ã‚’çœãã“ã¨ãŒã§ãã¾ã™ã€‚ ãŸã¨ãˆã°ã€ CREATE VIEW mytable_foo AS SELECT * FROM mytable WHERE id = 'foo'; ã¨ã—ã¦ãŠãã¨ã€ SELECT * FROM mytable_foo; ã¨ã™ã‚‹ã ã‘ã§ã€ SELE
{{#tags}}- {{label}}
{{/tags}}