[B! postgresql] uxoruã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

uxoru id:uxoru

postgresqlã«é–¢ã™ã‚‹uxoruã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (25)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã€ŒPostgreSQL 15ã€ãŒæ£å¼ãƒªãƒªãƒ¼ã‚¹ ï½žã€ŒMERGEã€ã‚³ãƒžãƒ³ãƒ‰ã«å¯¾å¿œã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚‚å‘ä¸Šï¼ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
uxoru 2022/10/15
postgresql
ãƒªãƒ³ã‚¯
PostgreSQL 15ã§ã¯publicã‚¹ã‚ãƒ¼ãƒžã¸ã®æ›¸ãè¾¼ã¿ãŒåˆ¶é™ã•ã‚Œã¾ã™ | DevelopersIO
PostgreSQLã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹ã¨ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ public ã‚¹ã‚ãƒ¼ãƒžãŒä½œæˆã•ã‚Œã€ä»»æ„ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã“ã®ã‚¹ã‚ãƒ¼ãƒžã«ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œæˆã§ãã¾ã—ãŸã€‚ CVE-2018-1058 ã§publicã‚¹ã‚ãƒ¼ãƒžã®ã“ã®ä»•æ§˜ã¨search_pathã‚’ä½¿ã£ãŸãƒˆãƒã‚¤ã®æœ¨é¦¬æ”»æ’ƒã®è„†å¼±æ€§(ä»•æ§˜ã®æ½œåœ¨ãƒªã‚¹ã‚¯)ãŒå ±å‘Šã•ã‚Œã¾ã—ãŸã€‚ ã“ã®æ”»æ’ƒã‹ã‚‰å®ˆã‚‹ãŸã‚ã«ã€ä»¥ä¸‹ã®ã‚ˆã†ãªæ–¹æ³•ãŒæŽ¨å¥¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ public ã‚¹ã‚ãƒ¼ãƒžã® CREATE æ¨©é™ã‚’ REVOKE ãƒ¦ãƒ¼ã‚¶ãƒ¼ã”ã¨ã«ã‚¹ã‚ãƒ¼ãƒžã‚’å‰²ã‚ŠæŒ¯ã‚‹ search_path ã« public ã‚¹ã‚ãƒ¼ãƒžãŒå«ã¾ã‚Œãªã„ã‚ˆã†ã«èª¿æ•´ PostgreSQL 15ã‹ã‚‰ã¯ã€1ã¤ç›®ã®å›žé¿ç–ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æœ‰åŠ¹ã«ãªã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚ªãƒ¼ãƒŠãƒ¼ã ã‘ãŒpublicã‚¹ã‚ãƒ¼ãƒžã«ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œæˆã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ Remove PUBLIC creation permission on the pu
uxoru 2022/07/23
postgresql
ãƒªãƒ³ã‚¯
ï¼»é€Ÿå ±ï¼½Googleã€Amazon Auroraã«å¯¾æŠ—ã™ã‚‹é«˜æ€§èƒ½DBã€ŒAlloyDB for PostgreSQLã€ç™ºè¡¨ã€‚é€šå¸¸ã®PostgreSQLã‚ˆã‚ŠOLTPãŒ4å€é«˜é€Ÿã€OLAPãŒ100å€é«˜é€Ÿã¨
Google Cloudã¯é–‹å‚¬ä¸ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒGoogle I/O 2022ã€ã§ã€PostgreSQLãƒ•ãƒ«äº’æ›ã®é«˜æ€§èƒ½ãªæ–°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€ŒAlloyDB for PostgreSQLã€ã®ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ãƒªãƒªãƒ¼ã‚¹ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ Google Cloudã¯ä»¥å‰ã‹ã‚‰PostgreSQLã®ãƒžãƒãƒ¼ã‚¸ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã€ŒCloud SQL for PostgreSQLã€ã‚’æä¾›ã—ã¦ã„ã¾ã™ã€‚ä»Šå›žç™ºè¡¨ã•ã‚ŒãŸã€ŒAlloyDB for PostgreSQLã€ã¯ã€Googleã®ã‚¯ãƒ©ã‚¦ãƒ‰ã‚¤ãƒ³ãƒ•ãƒ©ã‚„æ©Ÿæ¢°å¦ç¿’ã®æŠ€è¡“ã‚’ç©æ¥µçš„ã«æŠ•å…¥ã—ã€ã‚ˆã‚Šé«˜æ€§èƒ½ã‹ã¤ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«å‘ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦æ§‹ç¯‰ã—ãŸã‚‚ã®ã§ã™ã€‚ AWSã¨æ¯”è¼ƒã™ã‚‹ãªã‚‰ã°ã€ä¸€èˆ¬ç”¨é€”å‘ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ã€ŒAmazon RDSã€ã«å¯¾æŠ—ã™ã‚‹ã®ãŒGoogle Cloudã®ã€ŒCloud SQLã€ã§ã‚ã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚¯ãƒ©ã‚¦ãƒ‰ãƒã‚¤ãƒ†ã‚£ãƒ–ãªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨ã—ã¦
uxoru 2022/05/12
postgresql
ãƒªãƒ³ã‚¯
SQLite3 ã‚’ PostgreSQL ã«ã§ãã‚‹ã‚³ãƒžãƒ³ãƒ‰ postlite
ã¯ã˜ã‚ã« SQLite3 ãã‚‰ã„æ¥½ã«æ‰±ãˆã¦ã€PostgreSQL ã¿ãŸã„ã«ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯çµŒç”±ã§ä½¿ãˆã‚‹ç‰©ãªã„ã‹ãªãƒ¼ãªã‚“ã¦æ€ã£ãŸã‚Šã™ã‚‹äº‹ãªã„ã§ã™ã‹ï¼Ÿã‚ã‚Šã¾ã™ã‚ˆãã€ã‚ã‚‹ã‚“ã§ã™ã€‚ postlite ã“ã®ãƒ‹ãƒ¼ã‚ºã«ç”ãˆã¦ãã‚Œã‚‹ã®ãŒ postlite ã§ã™ã€‚postlite ã‚’ä½¿ã†ã¨ SQLite3 ã§ä½œã‚‰ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã€PostgreSQL ã®æ§˜ã«æ‰±ãˆã¾ã™ã€‚ ä»•çµ„ã¿ã¯è‡³ã£ã¦ç°¡å˜ã§ã€åƒ•ãŒé–‹ç™ºã—ã¦ã„ã‚‹ go-sqlite3 ã« PostgreSQL ã®é€šä¿¡ãƒ—ãƒãƒˆã‚³ãƒ«ã®ã‚¬ãƒ¯ã¨ã€ä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ã£ã¦ PostgreSQL ã®ã‚¹ã‚ãƒ¼ãƒžã‚’ç–‘ä¼¼ã—ã¦ã„ã¾ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« postlite ã¯ go-sqlite3 ã® vtable ã‚’ä½¿ã„ã¾ã™ã€‚ã§ã™ã®ã§ã€go install ã§ã¯ãªã postlite ã® README.md ã«æ›¸ã‹ã‚ŒãŸæ‰‹é †ã‚’ä½¿ã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚
uxoru 2022/04/02
postgresql

SQLite
ãƒªãƒ³ã‚¯
PostgreSQL ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è‚¥å¤§åŒ–ã¨å®Ÿè¡Œè¨ˆç”»ã®ã‚³ã‚¹ãƒˆã¸ã®å½±éŸ¿ - ã±ã¨éšŠé•·æ—¥èªŒ
ãŠçŸ¥ã‚‰ã› æœ¬è¨˜äº‹ã‚’ãƒ™ãƒ¼ã‚¹ã«æ–°ã—ã„è¨˜äº‹ã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ PostgreSQL ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è‚¥å¤§åŒ–ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚³ã‚¹ãƒˆã¸ã®å½±éŸ¿ï¼ˆå†ãƒ¢ãƒ‡ãƒ«åŒ–ï¼‰ - ã±ã¨éšŠé•·æ—¥èªŒ æ–°ã—ã„è¨˜äº‹ã§ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚³ã‚¹ãƒˆãƒ¢ãƒ‡ãƒ«ã®æ£ç¢ºæ€§ã‚’å‘ä¸Šã•ã›ã¾ã—ãŸã€‚ æ–°ã—ã„è¨˜äº‹ã‚’å‚ç…§ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ æ¦‚è¦ PostgreSQL ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚µã‚¤ã‚ºã¯ä¸€åº¦å¤§ãããªã‚‹ã¨ã€ãã®å¾Œå°ã•ããªã‚‹ã‚¿ã‚¤ãƒŸãƒ³ã‚°ãŒé™ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ ã€Œï¼»æ”¹è¨‚æ–°ç‰ˆï¼½å†…éƒ¨æ§‹é€ ã‹ã‚‰å¦ã¶PostgreSQL-è¨è¨ˆãƒ»é‹ç”¨è¨ˆç”»ã®é‰„å‰‡ã€ã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºãŒå°ã•ããªã‚‹ã®ã¯ä»¥ä¸‹ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã¨ã—ã¦ã„ã¾ã™ã€‚ DROP INDEX ã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è‡ªä½“ã‚’å‰Šé™¤ã—ãŸå ´åˆ TRUNCATE TABLE ã§ãƒ†ãƒ¼ãƒ–ãƒ«å…¨ä½“ã‚’ç©ºã«ã—ãŸå ´åˆ REINDEX ã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å†æ§‹æˆã—ãŸå ´åˆ [æ”¹è¨‚æ–°ç‰ˆ]å†…éƒ¨æ§‹é€ ã‹ã‚‰å¦ã¶PostgreSQL è¨è¨ˆãƒ»é‹ç”¨è¨ˆç”»ã®é‰„å‰‡ (Software Design p
uxoru 2021/06/07
postgresql
ãƒªãƒ³ã‚¯
S2JDBCã®iterate()ã§ OutOfMemoryError - ãƒã‚°æ—¥è¨˜
S2JDBCã‚’ä½¿ã£ã¦ DBã®ãƒ‡ãƒ¼ã‚¿æ•°åä¸‡ä»¶ã‚’ã¾ã¨ã‚ã¦DLã—ã‚ˆã†ã¨ã—ãŸã‚‰ã‚¨ãƒ©ãƒ¼ã«ãªã£ãŸã€‚ getResultList()ã˜ã‚ƒãªãã¦iterate()ä½¿ã£ãŸã‚‰çµæžœã‚’ã¾ã¨ã‚ã¦ä¿æŒã—ãªããªã‚‹ã‹ã‚‰ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã‚ãªããªã‚‹ã‚“ã˜ã‚ƒãªã„ã®ï¼Ÿã¨æ€ã£ãŸã‘ã©ãƒ€ãƒ¡ã€‚ Wicketã®ResourceStreamç³»ãŒã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ã‚‹ã®ã‹è‡ªåˆ†ã§æ›¸ã„ãŸã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’æ›¸ãå‡ºã™å‡¦ç†ãŒãƒŸã‚¹ã£ã¦ãŸã®ã‹ä½•ã‹ä½¿ã„æ–¹ãŒé–“é•ã£ã¦ãŸã®ã‹åˆ†ã‹ã‚‰ãšãƒãƒžã£ãŸã€‚ Eclipse Memory Analyzer ã§ãƒ€ãƒ³ãƒ—ã‚’è¦‹ãŸã‚‰ã€ã©ã“ã‹ã§ãƒ‡ãƒ¼ã‚¿ã‚’å…¨ä»¶ä¿æŒã—ã¦ã„ã‚‹æ¨¡æ§˜ã€‚ 2/29 ã“ã“ã‹ã‚‰è¿½è¨˜S2JDBC+PostgreSQLã ã¨s2jdbc.diconã®fetchSizeãƒ—ãƒãƒ‘ãƒ†ã‚£ã®è¨å®šï¼‹ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ãã¡ã‚“ã¨é–‹å§‹ã™ã‚‹ã€ã§è§£æ±ºã—ãã†ã€‚(ã¨ã‚Šã‚ãˆãšãƒãƒ¼ã‚«ãƒ«ç’°å¢ƒã§ã‚¨ãƒ©ãƒ¼ã®å†ç¾ â†’ ã‚¨ãƒ©ãƒ¼ä¿®æ£ã®ç¢ºèªã¾ã§ã¯ã§ããŸ) PostgreSQL: http://o
uxoru 2020/08/14
postgresql

jdbc
ãƒªãƒ³ã‚¯
100ä¸‡ä»¶ãã‚‰ã„ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ‰±ã£ãŸã‚‰OOMEãŒå‡ºãŸè©±ã€‚ - è°·æœ¬ å¿ƒ in ã›ã‚éƒ¨å±‹
è¦ç´„ æŠ€è¡“çš„ãªè©±ã ã‘æ•™ãˆã¦ã€ã¨ã„ã†æ–¹ã®ãŸã‚ã«å…ˆã«çµè«–ã ã‘æ›¸ã„ã¦ãŠãã¾ã™ã¨ã€PostgreSQLã¯ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ãŸæ™‚ç‚¹ã§å…¨ãƒ¬ã‚³ãƒ¼ãƒ‰ã®æƒ…å ±ã‚’ä¸€æ°—ã«èªã‚“ã§ãã¦ãƒ’ãƒ¼ãƒ—ã‚’åŸ‹ã‚ã¦ã—ã¾ã†å ´åˆãŒã‚ã‚‹ã€ã¨ã„ã†ã“ã¨è©±ã§ã™ã€‚ ãŸã¨ãˆã°ã€ResultSet#nextãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ã„ãªãŒã‚‰å‡¦ç†ã‚’å›žã™ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã€å°‘ãªã„ãƒ’ãƒ¼ãƒ—ã§ã‚‚å‡¦ç†ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã®ã¯å¸¸å¥—æ‰‹æ®µã ã¨æ€ã„ã¾ã™ãŒã€ãã†ã„ã†ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã„ã¦ã‚‚ä¸€æ°—ã«ãƒ’ãƒ¼ãƒ—ã‚’æ¶ˆè²»ã—ã¦ã—ã¾ã†ã“ã¨ãŒã‚ã‚‹ã®ã§ã™ã€‚è©³ã—ãã¯ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’è¦‹ã¦ãã ã•ã„ã€‚ https://jdbc.postgresql.org/documentation/head/query.html#query-with-cursor ã“ã¨ã®ç™ºç«¯ ã¡ã‚‡ã£ã¨ä»•äº‹ã§Java + jOOQ + PostgreSQLã§ã€DBã®ãƒ‡ãƒ¼ã‚¿ã‚’é›†è¨ˆã™ã‚‹ã‚ˆã†ãªãƒãƒƒãƒå‡¦ç†ã‚’æ›¸ã„ã¦ã¾ã—ã¦ã€ã‚‚ã¡ã‚ã‚“ä¿ºæ§˜ã®æ›¸ã„ãŸã‚³ãƒ¼ãƒ‰ã«ãƒã‚°ãªã‚“ã¦ã‚ã‚‹
uxoru 2020/08/13
postgresql

jdbc
ãƒªãƒ³ã‚¯
SELECTæ–‡ã§æœ¬ç•ªç’°å¢ƒã‚’è½ã¨ã—ãŸãŠè©± - Qiita
ï¼ˆã“ã®è¨˜äº‹ã¯ åœ°å¹³ç·šã«è¡Œã ã¨ã®ãƒžãƒ«ãƒãƒã‚¹ãƒˆã§ã™ï¼‰ æœ¬ç•ªç’°å¢ƒã§ã‚„ã‚‰ã‹ã—ã¡ã‚ƒã£ãŸäºº Advent Calendarã§ã€ã“ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã®ã‚„ã‚‰ã‹ã—ã¯ãªã‹ã£ãŸã®ã§ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚’å©ãã“ã¨ã«ã—ã¾ã—ãŸã€‚ ç•ªå¤–ç·¨ã®ã¤ã‚‚ã‚Šã§ãŠæ¥½ã—ã¿ãã ã•ã„ã€‚ ã“ã®è¨˜äº‹ãŒã€æ–°ãŸãªéšœå®³ç™ºç”Ÿã‚’é˜²ãã“ã¨ã«ã¤ãªãŒã‚Œã°å¹¸ã„ã§ã™ã€‚ ä½•ã‚’ã‚„ã£ãŸã®ã‹ ã‚ã‚‹æ—¥ã€ã¡ã‚‡ã£ã¨ã—ãŸèª¿æŸ»ã®ãŸã‚ã«æœ¬ç•ªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç¢ºèªã™ã‚‹ã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ï¼ˆå€‹äººæƒ…å ±ãŒæ ¼ç´ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã§ã¯ãªã‹ã£ãŸã®ã§ã€å¿…è¦ã§ã‚ã‚Œã°æœ¬ç•ªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒè¨±ã•ã‚Œã¦ã„ã¾ã—ãŸï¼‰ ã‚‚ã—ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ãŒã‚ã‚Œã°ãã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ã‚„ã‚Œã°ã‚ˆã‹ã£ãŸã®ã§ã™ãŒã€ç›´è¿‘ã§ã¯ç‰¹ã«äºˆå®šã¯ãªã„ã¨ã®ã“ã¨ã§ã—ãŸã€‚ãã®ãŸã‚ã€ã‚·ã‚¹ãƒ†ãƒ ãŒå‹•ã„ã¦ã„ã‚‹çŠ¶æ…‹ã®ã¾ã¾ä½œæ¥ã‚’ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã”ãå˜ç´”ãª SELECT ã‚’å®Ÿè¡Œã™ã‚‹ã ã‘ã®ã¤ã‚‚ã‚Šã ã£ãŸã®ã§ã€ã‚·ã‚¹ãƒ†ãƒ ã«å½±éŸ¿ãŒãªã„ã¨åˆ¤æ–ã—ãŸãŸã‚ã§ã™ã€‚ ãã®éš›ã€ä¸‡ãŒä¸€ã‚³ãƒ”ãƒšã‚’ãƒŸ
uxoru 2019/12/26
SQL

å¤±æ•—è«‡

postgresql
ãƒªãƒ³ã‚¯
postgresã®ãƒ‡ãƒ¼ã‚¿ã‚’ç›—ã¾ã‚ŒãŸè©± - ã®ã‚“ã³ã‚Šã‚„ã®æ—¥è¨˜
ã¯ã˜ã‚ã« ã•ã£ã¶ã€‚ã©ã†ã‚‚ã€ã ãƒ¼ã‚„ã¾ã‚“ã§ã™ã€‚ ã“ã®è¨˜äº‹ã¯ã€æœ¬ç•ªç’°å¢ƒã§ã‚„ã‚‰ã‹ã—ã¡ã‚ƒã£ãŸäºº Advent Calendar 2019 - Qiitaã®11æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ã“ã‚Œã¯ã€ä¸é€”åŠç«¯ãªçŸ¥è˜ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’é‹ç”¨ã—ã¦ã„ãŸçµæžœã€ã‚¿ã‚¤ãƒˆãƒ«é€šã‚Šã®å¤§å¤±æ•—ã‚’ã—ã¦ã—ã¾ã£ãŸãŠè©±ã§ã™ã€‚å€‹äººé–‹ç™ºã§ã®å‡ºæ¥äº‹ãªã®ã§ã€æ¥å‹™ã§èµ·ããŸã“ã¨ã‹ã¨èƒƒè–¬ã‚’æ¡ã‚‰ã‚Œã¦ã„ãŸæ–¹ã¯ã”å®‰å¿ƒãã ã•ã„ã€‚ èªžã‚‹ã®ã‚‚ã™ã”ã„æ¥ãšã‹ã—ã„ãƒ¬ãƒ™ãƒ«ã§ã™ãŒã€æˆ’ã‚ã®ãŸã‚ã«æ™’ã—ã¦ãŠãã¾ã™ã€‚ ã“ã®è¨˜äº‹ã‚’èªã‚“ã§ã»ã—ã„äºº åˆã‚ã¦ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆä¸Šã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’å…¬é–‹ã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹äºº å–‹å¤ªéƒŽã®åˆ©ç”¨è€…æ§˜(ã“ã®å ´ã‚’ãŠå€Ÿã‚Šã—ã¦ã€æ”¹ã‚ã¦ãŠè©«ã³ç”³ã—ä¸Šã’ã¾ã™ã€‚æœ¬å½“ã«ç”³ã—è¨³ã”ã–ã„ã¾ã›ã‚“ã§ã—ãŸã€‚) èƒŒæ™¯ã¨ã‹ Discordèªã¿ä¸Šã’Bot ã€Œå–‹å¤ªéƒŽã€ã«ã¦ã‚„ã‚‰ã‹ã—ã¾ã—ãŸ www.dayaman.work åˆ©ç”¨è€…ãŒç´„10ä¸‡äºº ã•ãã‚‰ã®VPSã«ã¦Appã‚µãƒ¼ãƒ2å°ã€DBã‚µãƒ¼ãƒ1å°ã§é‹ç”¨ å„ã‚µãƒ¼ãƒã®æ»æ´»ç›£è¦–
uxoru 2019/12/11
å¤±æ•—è«‡

postgresql
ãƒªãƒ³ã‚¯
ã€Œè„±Oracleã€ã®èƒŒæ™¯ã«ã‚ã‚‹ã€Oracle Databaseã®ä¾¡å€¤ã‚’æ”¹ã‚ã¦è€ƒãˆã‚‹ | ãƒ•ãƒ¥ãƒ¼ãƒãƒ£ãƒ¼æŠ€è¡“ãƒ–ãƒã‚°
ã¯ã˜ã‚ã«2019å¹´10æœˆ15æ—¥ã€Amazonã¯è‡ªç¤¾ã‚µãƒ¼ãƒ“ã‚¹ã«ãŠã‘ã‚‹å®Ÿè³ªçš„ãªâ€è„±Oracleâ€ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚75PBã«åŠã¶ãƒ‡ãƒ¼ã‚¿ã‚’ã€å‚˜ä¸‹ã®AWSãŒæä¾›ã™ã‚‹Database Serviceï¼ˆAuroraã‚„DynamoDBã€Redshiftãªã©ï¼‰ã¸ã¨ç§»è¡Œã—ãŸã¨ã®äº‹ã€‚ ã“ã®ä¸€å ±ã¯ã€Amazonã¨ã„ã†ã‚°ãƒãƒ¼ãƒãƒ«è¦æ¨¡ã®ECã®å·¨äººã€ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ»ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒžãƒ¼ã®ãƒªãƒ¼ãƒ€ãƒ¼ã®ä¸€è§’ãŒã€å¤§è¦æ¨¡åŸºå¹¹ã‚·ã‚¹ãƒ†ãƒ é ˜åŸŸã«ãŠã‘ã‚‹RDBMSã®ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆãƒ»ã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã¨æ±ºåˆ¥ã—ãŸã¨ã„ã†ç‚¹ã§ã€æ¥ç•Œé–¢ä¿‚è€…ã«å¯¾ã—ã¦éžå¸¸ã«å¤§ããªã‚¤ãƒ³ãƒ‘ã‚¯ãƒˆã‚’æ®‹ã—ãŸã‚‚ã®ã‹ã¨æ€ã„ã¾ã™ã€‚ å¤§äººã®è‰²ã€…ãªå´é¢ãŒåž£é–“è¦‹ãˆã‚‹ã‚‚ã®ã®ã€éžå¸¸ã«é›£æ˜“åº¦ã®ç§»è¡ŒPJã§ã‚ã£ãŸäº‹ã¯ã‚’æƒ³åƒã«é›£ãã‚ã‚Šã¾ã›ã‚“ã€‚ â€œOracleã‚‚ã„ã‚ˆã„ã‚ˆè³žå‘³æœŸé™ã‚’è¿Žãˆã‚‹â€ æžœãŸã—ã¦ãã†ãªã®ã‹ã€‚ã“ã“ã§ä»Šä¸€åº¦ã€**â€è„±Oracleâ€ã¨ã¯ä½•ã‚’è„±ã™ã‚‹äº‹ãªã®ã‹**ã€ã‚’è€ƒãˆã¦ã¿ã¾ã™ã€‚ â€œè„±Oracleâ€ã¨ã¯ï¼Ÿç¬¬1ã¯é«˜
uxoru 2019/11/21
Oracle

postgresql

Amazon
ãƒªãƒ³ã‚¯
ã¯ã—ã‚™ã‚ã¦ã®PostgreSQLãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚¯ã‚™å…¥é–€ / PostgreSQL 11 Monitoring
ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãƒžãƒãƒ¼ã‚¸ãƒ£ãƒ¼è¦–ç‚¹ã§ã®ã€è‡ªå¾‹çš„ãªã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚°ã‚’å®Ÿç¾ã™ã‚‹FASTã¨ã„ã†é¸æŠžè‚¢ / RSGT2025
uxoru 2019/11/15
postgresql

ã‚ã¨ã§çµ¶å¯¾èªã‚
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
uxoru 2012/09/12
postgresql

MySQL
ãƒªãƒ³ã‚¯
PostgreSQLã®CSVå–ã‚Šè¾¼ã¿
PostgreSQLã§CSVç‰ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šè¾¼ã‚€æ–¹æ³•ã¯ã€ ãƒ¡ã‚¿ã‚³ãƒžãƒ³ãƒ‰ã®[/copy]ã‚’ä½¿ç”¨ã™ã‚‹æ–¹æ³•ã¨ã€SQLã‹ã‚‰[COPY]æ–‡ã‚’ä½¿ç”¨ã™ã‚‹æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ ãƒ¡ã‚¿ã‚³ãƒžãƒ³ãƒ‰ã®[/copy]ã¯ã€ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã—ãŸãƒ›ã‚¹ãƒˆä¸Šã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ“ä½œã—ã€ SQLã®[COPY]æ–‡ã¯ã€PostgreSQLã‚µãƒ¼ãƒä¸Šã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ“ä½œã™ã‚‹ã¨ã„ã†é•ã„ãŒã‚ã‚Šã¾ã™ã€‚ ä»Šå›žã¯ã€SQLã®[COPY]æ–‡ã‚’ä½¿ç”¨ã™ã‚‹éš›ã®ãƒã‚¤ãƒ³ãƒˆã‚’3ã¤ã€ã”ç´¹ä»‹ã—ã¾ã™ã€‚ â– ãƒã‚¤ãƒ³ãƒˆ1ã€Œãƒ‘ã‚¹ã®æŒ‡å®šã«æ³¨æ„ï¼ã€ ã¾ãšã¯ã€åŸºæœ¬çš„ãªæ§‹æ–‡ã§ã™ã€‚ COPY [ãƒ†ãƒ¼ãƒ–ãƒ«å] FROM [ãƒ•ã‚¡ã‚¤ãƒ«ã®çµ¶å¯¾ãƒ‘ã‚¹]; ãƒ•ã‚¡ã‚¤ãƒ«ã®çµ¶å¯¾ãƒ‘ã‚¹ã‚’æŒ‡å®šã™ã‚‹éš›ã«æ°—ã‚’ã¤ã‘ãªã‘ã‚Œã°ãªã‚‰ãªã„ã®ã¯ã€ ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥(\)ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ï¼ˆä¾‹ï¼šC:\\Program Files\\PostgreSQLï¼‰ â– ãƒã‚¤ãƒ³ãƒˆ2ã€ŒTIMESTAMPåž‹ã«æ³¨æ„ï¼
uxoru 2012/03/16
COPYã‚³ãƒžãƒ³ãƒ‰

postgresql
ãƒªãƒ³ã‚¯
Mac OS X ã§ PostgreSQL ã‚’ä½¿ã£ã¦ã¿ã‚ˆã† (1) â€” Let's Postgres
ç¬¬å››ä¼ç”»Â å‚äº• æ½” ã¯ã˜ã‚ã« ã“ã®è¨˜äº‹ã§ã¯ã€Mac OS X ã®ç¾æ™‚ç‚¹ï¼ˆ2009-05-16ï¼‰ã§ã®æœ€æ–°ç‰ˆã§ã‚ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 10.5.7 (Leopard) ã«ã€ä»Šå›žã¯ EnterpriseDB ç¤¾ãŒæä¾›ã™ã‚‹ã€Œãƒ¯ãƒ³ãƒ»ã‚¯ãƒªãƒƒã‚¯ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã‚’ä½¿ã£ã¦ç°¡å˜ã« PostgreSQL ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã€å‹•ã‹ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ 1. ç”¨æ„ã™ã‚‹ã‚‚ã® 1.1 Mac ç†è€…ãŒä½¿ç”¨ã—ãŸ Macintosh ã¯ã€ä¸€ä¸–ä»£å‰ã® MacBook White ã§ã™ã€‚ ãƒ—ãƒã‚»ãƒƒã‚µ
uxoru 2012/02/02
OS X

postgresql
ãƒªãƒ³ã‚¯
PostgreSQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’CSVãƒ€ãƒ³ãƒ—ã™ã‚‹ - /dev/blog
DBã®ãƒ‡ãƒ¼ã‚¿ã‚’è‡ªåˆ†ã§ä½œæˆã—ãŸãƒ—ãƒã‚°ãƒ©ãƒ ã§æ›´æ–°ã—ãŸæ™‚ã«ã€ã©ã†ã‚„ã£ã¦æ¤œè¨¼ã‚’ã™ã‚‹ã‹ã¨ã„ã†å†…å®¹ã§ã™ã€‚ PostgreSQLã«ã¯COPYæ–‡ã§CSVã«å‡ºåŠ›ã™ã‚‹ã“ã¨ãŒå¯èƒ½ãªã®ã§ã€å‡ºåŠ›ã—ãŸCSVã‚’æ›´æ–°å‰å¾Œã§diffã‚Šã¾ã—ãŸã€‚ ã¾ãšã¯DBã®ä¸èº«ã¯ã“ã‚“ãªæ„Ÿã˜ã€‚testã¨ã„ã†åå‰ã®DBã«â†“ã®æ§˜ãªãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚Œã¦ãŠãã¾ã™ã€‚ test=# SELECT * FROM test_table; id | name | tel ----+-----------+------------ 1 | yamada | 012345678 2 | takahashi | 123456789 3 | suzuki | 234567890 1 | takeda | 3456789012 (4 rows)ã‚³ãƒžãƒ³ãƒ‰ã¯ã€ä»¥ä¸‹ã€1è¡Œã ã‘ã€‚ psql <DBå> -c "COPY <ãƒ†ãƒ¼ãƒ–ãƒ«å> TO '<ãƒ•ã‚¡ã‚¤ãƒ«å>' CSV -------
uxoru 2012/02/02
postgresql
ãƒªãƒ³ã‚¯
MyKnowledge SEç¤¾å“¡: index ï½ž List
å½“ã‚µã‚¤ãƒˆèª¬æ˜Žï¼š ã‚·ã‚¹ãƒ†ãƒ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢(SE)ã®çŸ¥æµã‚’ç´¹ä»‹è‡´ã—ã¾ã™ã€‚Oracle ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€PostgreSQL ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€VERITAS VCSã€Oracle MVã€Oracle éšœå®³ã®å›žå¾©ã€Ruby on Rails ãªã©ã‚«ãƒ†ã‚´ãƒªåˆ¥ã«çºã‚ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ã¾ãŸã€ã‚·ã‚¹ãƒ†ãƒ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢(SE)ã®è»¢è·æƒ…å ±ãªã©ã‚‚ç´¹ä»‹è‡´ã—ã¾ã™ã€‚ è³‡æ ¼ï¼š æƒ…å ±å‡¦ç†æŠ€è¡“è€…è©¦é¨“ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºæŠ€è¡“è€…è©¦é¨“ Oracle9i Master
uxoru 2009/09/16
ãŠãŠï¼ã‚·ãƒ³ãƒ—ãƒ«ã«ã¾ã¨ã¾ã£ã¦ã¦ä¾¿åˆ©ï¼

tips

Oracle

postgresql

Unix
ãƒªãƒ³ã‚¯
PostgreSQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢
PostgreSQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢Â Â Â æœ¬ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã¤ã„ã¦å¿…ãšãŠèªã¿ãã ã•ã„ Wiz ã‚’ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã—ã¦ã¿ã‚ˆã† > PostgreSQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢ â– PostgreSQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢ â– ãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ç¾åœ¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿å˜ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¾ã™ã€‚ pg_dump ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ â€» PostgreSQLãŒèµ·å‹•ã—ã¦ã„ãªã„å ´åˆã‚¨ãƒ©ãƒ¼ã«ãªã‚Šã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¾ã™ã€‚
uxoru 2008/07/09
postgresql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
uxoru 2008/07/04
postgresql
ãƒªãƒ³ã‚¯
[pgsql-jp: 30020] Re: ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ãŒæœ€å¤§æ•°ã‚’è¶Šãˆã¾ã™
uxoru 2008/06/26
ã„ã¤ã‚‚å¿˜ã‚Œã‚‹

postgresql
ãƒªãƒ³ã‚¯
Huge Database problem - ChemAxon Forum Archive
uxoru 2008/06/12
ã“ã‚Œã‚‚ã‚¢ãƒ—ãƒªã®OutOï½†Memoryâ†’"org.postgresql.util.PSQLException: Ran out of memory retrieving query results. "

Java

postgresql

jdbc
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸