[B! postgre_sql] xai1981ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

xai1981 id:xai1981

postgre_sqlã«é–¢ã™ã‚‹xai1981ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{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] ã‚ˆãä½¿ã†ã‚³ãƒžãƒ³ãƒ‰ã¾ã¨ã‚ | DevelopersIO
ã¯ã˜ã‚ã« PostgreSQLå§‹ã‚ã¾ã—ãŸã€‚ Mysqlã®æ„Ÿè¦šã§PostgreSQLã‚’è§¦ã‚‹ã¨ã‚³ãƒžãƒ³ãƒ‰ãŒé•ã†ã“ã¨ãŒå¤šã„ã®ã§ã€ãã®éƒ½åº¦Googleå…ˆç”Ÿã«æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ PostgreSQLã®ã‚³ãƒžãƒ³ãƒ‰ãŒã¾ã¨ã¾ã£ã¦ã„ã‚‹ã‚µã‚¤ãƒˆã‚’è¦‹ã¤ã‘ã‚‰ã‚Œãªã‹ã£ãŸã®ã§ã€è‡ªåˆ†ç”¨ã«ãƒ¡ãƒ¢ã—ã¦ã„ãŸã‚‚ã®ã‚’å…¬é–‹ã—ã¾ã™ã€‚ æ³¨) åƒ•ãŒPostgreSQLã§ã‚ˆãä½¿ã†ã‚³ãƒžãƒ³ãƒ‰ã‚„ä½•åº¦ã‚‚èª¿ã¹ãŸã‚³ãƒžãƒ³ãƒ‰ã®ã¾ã¨ã‚ã§ã™ã€‚PostgreSQLç‰¹æœ‰ã®ã‚³ãƒžãƒ³ãƒ‰ã®ã¾ã¨ã‚ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ â€»#ã‹ã‚‰å§‹ã¾ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã¯psqlå†…ã§ã€$ã‹ã‚‰å§‹ã¾ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã¯psqlå¤–ã§å®Ÿè¡Œã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã«ãªã‚Šã¾ã™ã€‚ â€»<TABLE_NAME>ã®ã‚ˆã†ã«è¨˜è¿°ã—ã¦ã„ã‚‹ç®‡æ‰€ã¯ã€ä»»æ„ã®åå‰ã‚’è¨˜å…¥ã™ã‚‹ç®‡æ‰€ã§ã™ã€‚(<>ã¯ä¸è¦ã§ã™) ç’°å¢ƒ MacOS 10.10.5 PostgreSQL 9.4.5 ã‚ˆãä½¿ã†ã‚³ãƒžãƒ³ãƒ‰ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ç¢ºèªã™ã‚‹ $ psql â€”version # select ver
xai1981 2017/05/30
postgre_sql
ãƒªãƒ³ã‚¯
Dockerå…¬å¼ã‚¤ãƒ¡ãƒ¼ã‚¸ã§é–‹ç™ºç”¨RDBã‚’ã‚²ãƒƒãƒˆã ãœ(PostgreSQLç·¨) Â« LANCARD.LABï½œãƒ©ãƒ³ã‚«ãƒ¼ãƒ‰ã‚³ãƒ ã®ã‚¹ã‚¿ãƒƒãƒ•ãƒ–ãƒã‚°
ã¾ãˆãŒã Laravelã§ã®é–‹ç™ºæ™‚ã«ãƒ‡ãƒ—ãƒã‚¤å…ˆã¯MySQLãªã®ã«æ‰‹ã‚’æŠœã„ã¦æ‰‹å…ƒã®é–‹ç™ºæ©Ÿã§ã¯SQLiteã‚’ä½¿ã£ã¦ã„ãŸã‚‰ç—›ã„ç›®ã«ã‚ã£ãŸã‚Šã—ã¾ã—ãŸã€muraveã§ã™ã€‚ SQLiteã£ã¦çµæ§‹ãƒ«ãƒ¼ã‚ºã«ã¤ã‹ãˆã¦ã—ã¾ã†ã®ã§æ‰‹å…ƒã®é–‹ç™ºã§SQLiteä½¿ã£ã¦ã¦MySQLé‹ç”¨ã®ã‚µãƒ¼ãƒãƒ¼ã«ãƒ‡ãƒ—ãƒã‚¤ã™ã‚‹ã¨ã‚¨ãƒ©ãƒ¼ãŒãƒãƒ³ãƒãƒ³ã¨ã„ã†ã®ãŒæ˜¨æ—¥ã‹ã‚‰é€£ç¶šç™ºç”Ÿä¸ã€‚ â€” murave (@murave) 2016å¹´7æœˆ14æ—¥ é–‹ç™ºç’°å¢ƒã«ã‚ã¾ã‚Šå½±éŸ¿ã‚’ä¸Žãˆãšã«ã‚µã‚¯ãƒƒã¨é–‹ç™ºç”¨ã®RDB(Relational Database)ã‚’å»ºã¦ã‚‰ã‚Œã‚‹ã¨ç´ æ•µã§ã™ãã€‚Dockerå…¬å¼ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’æ´»ç”¨ã™ã‚‹ã¨å‡ºæ¥ãã†ã§ã™ã€‚ RDBã¨ã„ã†ãƒ‡ãƒƒã‚«ã‚¤å˜èªžã‚’ä½¿ã£ã¦ã„ã¾ã™ãŒã€è‡ªåˆ†ãŒã‚ˆãä½¿ã†PostgreSQLã€MySQLã€MariaDBãªã©ã«ã¤ã„ã¦èª¿ã¹ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚MySQLã¨MariaDBè‡ªä½“ã¯ã»ã¼åŒã˜æ‰±ã„æ–¹ãŒã§ãã‚‹RDBã§ã™ãŒã€å…¬å¼ã‚¤ãƒ¡ãƒ¼ã‚¸ã§ã®æ‰±ã„ã¯ã©ã†ãªã‚“ã§ã—ã‚‡
xai1981 2017/05/05
docker

postgre_sql

database
ãƒªãƒ³ã‚¯
pg_restore toc error
i was using the following syntax for pg_dump and restore pg_dump eval --inserts -b -c --encoding UTF8 -Fc -f eval.sql.tar.gz -x -U postgres createdb -T template0 test -U postgres pg_restore -d test eval.sql.tar.gz -e -U postgres the dump was successfull with no errors, but restore makes a some errors, i am dumping and restoring in same machine with same user and privilege all... i have tried out w
xai1981 2017/05/05
stack_overflow

database

qa

postgre_sql
ãƒªãƒ³ã‚¯
cyber-funnel.com
cyber-funnel.com 2024 è‘—ä½œæ¨©. ä¸è¨±è¤‡è£½ ãƒ—ãƒ©ã‚¤ãƒã‚·ãƒ¼ãƒãƒªã‚·ãƒ¼
xai1981 2017/05/02
backup

postgre_sql
ãƒªãƒ³ã‚¯
PostgreSQLã®backup, restoreæ–¹æ³•ã¾ã¨ã‚ - Qiita
(1) PostgreSQLã®ãƒ€ãƒ³ãƒ—ãƒ„ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã—ãŸãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— pg_dumpã‚³ãƒžãƒ³ãƒ‰ DBã‚’é‹ç”¨ã—ãªãŒã‚‰ã§ã‚‚ä½¿ãˆã‚‹backupã‚³ãƒžãƒ³ãƒ‰ ä¸ã§ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒ–ãƒãƒƒã‚¯å†…ã§SELECTæ–‡ã‚’ç™ºè¡Œã—ã€å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’å‡ºåŠ›å½¢å¼ã«åˆã‚ã›ã¦æ•´å½¢ã—ãŸè…•æ¨™æº–å‡ºåŠ›ã«å‡ºåŠ› ã™ã‚‹ã‚‰ã—ã„ã€‚ pg_dumpã®å‡ºåŠ›å½¢å¼ ã‚¹ã‚¯ãƒªãƒ—ãƒˆå½¢å¼(ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ) ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–å½¢å¼ ãŒé¸æŠžã§ãã‚‹ã€‚ ã‚¹ã‚¯ãƒªãƒ—ãƒˆå½¢å¼ ã‚¹ã‚¯ãƒªãƒ—ãƒˆå½¢å¼ã®å‡ºåŠ›ã¯ã€ãƒªã‚¹ãƒˆã‚¢ã«å¿…è¦ãªSQLæ–‡ã®ç¾…åˆ—ãŒå‡ºã‚‹ã€‚ ã®ã§ã€psqlã‚³ãƒžãƒ³ãƒ‰ã§ãƒªã‚¹ãƒˆã‚¢ã™ã‚‹ã€‚ ã‚¹ã‚¯ãƒªãƒ—ãƒˆå½¢å¼ã®å ´åˆã¯ãƒ—ãƒ¬ãƒ¼ãƒ³ãƒ†ã‚ã‚¹ãƒˆãªã®ã§ã€ãƒªã‚¹ãƒˆã‚¢ã®éš›ã«ã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸã‚‰ã€ä¸ã‚’è¦‹ã‚Œã‚‹ã¨ã„ã†åˆ©ç‚¹ãŒã‚ã‚‹ã€‚ ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–å½¢å¼ ãƒã‚¤ãƒŠãƒªã®å½¢ã§å‡ºåŠ›ã•ã‚Œã‚‹ã€‚ãƒªã‚¹ãƒˆã‚¢ã¯psqlã‚³ãƒžãƒ³ãƒ‰ã§ãªãpg_restoreã‚³ãƒžãƒ³ãƒ‰ã§è¡Œã†ã€‚ ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–å½¢å¼ã®åˆ©ç‚¹ã¯ã€ ï½¢æŒ‡å®šã—ãŸtableã®ã¿ã‚’é¸æŠžã—ã¦ãƒªã‚¹ãƒˆã‚¢ã§ãã‚‹ï½£ã“ã¨ã‚‰ã—ã„ã€‚ ã¾ãŸã€ã‚¢ãƒ¼ã‚«
xai1981 2017/05/02
database

qiita

postgre_sql
ãƒªãƒ³ã‚¯
PostgreSQLã‚¹ã‚ãƒ«ã‚¢ãƒƒãƒ—ãƒŽãƒ¼ãƒˆ
ãƒ‘ã‚¿ãƒ¼ãƒ³ãƒžãƒƒãƒãƒ»ãã®ï¼‘ï¼ˆLIKEåŠã³SIMILAR TOï¼‰ã€ä¸€è¦§ã«æˆ»ã‚‹ã€‘â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â” â– â– â– â– PostgreSQL ã‚¹ã‚ãƒ«ã‚¢ãƒƒãƒ—ãƒŽãƒ¼ãƒˆ â– â– â– â– â– â—†â– â– ãƒ‘ã‚¿ãƒ¼ãƒ³ãƒžãƒƒãƒãƒ»ãã®ï¼‘ï¼ˆLIKEåŠã³SIMILAR TOï¼‰ â– â– â– â– â– â– â– â– â– â– â– â– 2013/01/04 â– â– â– â– ä½¿ç”¨ç’°å¢ƒï¼šPostgreSQL9.1.4 (CentOS6.2) (C) 2012 ohdb â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â”â” â˜…è‡ªå·±éƒ½åˆã«ã‚ˆã‚Šãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã¸ã®ãƒªãƒ³ã‚¯ã¯9.2ã¨ã—ã¦ã„ã¾ã™ã€‚ã”äº†æ‰¿ä¸‹ã•ã„ã€‚ â˜…ã“ã®ãƒšãƒ¼ã‚¸ã¯ãã®ã¾ã¾ã‚«ãƒƒãƒˆ&ãƒšãƒ¼ã‚¹ãƒˆã§å®Ÿè¡Œã—ã¦è©¦ã™ã“ã¨ãŒã§ãã¾ã™ã€‚ ã€ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã€‘ ãƒ‘ã‚¿ãƒ¼ãƒ³ãƒžãƒƒãƒ â†’â—[ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«] ã€å‚è€ƒè¨˜äº‹ã€‘ ï¼ ã€ç”¨èªžç‰ã€‘ PostgreSQLã®ãƒ‘ã‚¿ãƒ¼ãƒ³ãƒžãƒƒãƒã¯å¤§åˆ¥ã—ã¦ï¼“ç¨®
xai1981 2016/03/16
postgre_sql

regular_expression
ãƒªãƒ³ã‚¯
PostgreSQLã‚’ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§æ“ä½œã™ã‚‹
ä»Šå›žã®ãŠã‚‚ãªå†…å®¹ ã‚½ãƒ¼ã‚¹ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã¨ãƒã‚¤ãƒŠãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« PostgreSQLã®åˆæœŸåŒ– ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’æ“ä½œã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ selectæ–‡ã§æ¤œç´¢ psqlã§ä½¿ãˆã‚‹ã‚³ãƒžãƒ³ãƒ‰ä¸€è¦§ PostgreSQLã¯ã€Linuxã‚„FreeBSDãŠã‚ˆã³ä¸€éƒ¨ã®å•†ç”¨UNIXã§ã¯ã€ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚·ã‚¹ãƒ†ãƒ ã‚’ç”¨ã„ã¦ç°¡å˜ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ã€‚ãŸã ã—RedHatç³»ã®Linuxï¼ˆRedHatã‚„Turbo Linuxã€Vine Linuxãªã©ï¼‰ã§ã¯ã€/usrç›´ä¸‹ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªï¼ˆ/usr/binã‚„/usr/libï¼‰ã«ãƒ•ã‚¡ã‚¤ãƒ«ãŒé…ç½®ã•ã‚Œã¦ã€å¾Œã§ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã™ã‚‹å ´åˆãªã©ã«å°‘ã—æˆ¸æƒ‘ã„ã‚’æ„Ÿã˜ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ï¼ˆå˜ã«ç†è€…ã ã‘ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒ^^;;ï¼‰ã€‚ ãã†ã„ã†ã¨ãã¯ã€ãœã²ã¨ã‚‚PostgreSQLã‚’ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¾ã—ã‚‡ã†ã€‚ãã®æ‰‹é †ã‚’ç´¹ä»‹ã—
xai1981 2016/03/15
postgre_sql
ãƒªãƒ³ã‚¯
PostgreSQLã¸ã®æŽ¥ç¶šã¨åˆ‡æ–
psql ã‚’ä½¿ç”¨ã—ã¦ PostgreSQL ã¸æŽ¥ç¶šã‚’è¡Œã£ãŸã‚Šã€ PostgreSQL ã‹ã‚‰åˆ‡æ–ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã“ã§ã¯ psql ã‚’ä½¿ã£ã¦ PostgreSQL ã¸æŽ¥ç¶šã™ã‚‹æ–¹æ³•ãŠã‚ˆã³ PostgreSQL ã‹ã‚‰åˆ‡æ–ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ PostgreSQLã¸æŽ¥ç¶šã™ã‚‹ psql ã¯ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ™ãƒ¼ã‚¹ã§ PostgreSQL ã§ä½œæˆæ¸ˆã¿ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã—ãŸã‚Šãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ Windowsç’°å¢ƒã‹ã‚‰ psql ã‚’åˆ©ç”¨ã™ã‚‹ã«ã¯ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã‹ã‚‰è¡Œã„ã¾ã™ã€‚ æœ€åˆã«ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’èµ·å‹•ã—ã¦ãã ã•ã„ã€‚(ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã®èµ·å‹•æ–¹æ³•ã«ã¤ã„ã¦ã¯ã€Œã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’èµ·å‹•ã™ã‚‹ã€ã‚’å‚ç…§ã•ã‚Œã¦ãã ã•ã„)ã€‚ psql ã‚’ä½¿ã£ã¦ PostgreSQL ã¸æŽ¥ç¶šã™ã‚‹ã«ã¯æ¬¡ã®ã‚ˆã†ã«å®Ÿè¡Œã—ã¾ã™ã€‚(å®Ÿéš›ã«ã¯ PostgreSQL ã§ä½œæˆæ¸ˆã¿ã®æŒ‡å®šã—ãŸãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
xai1981 2016/03/15
command

postgre_sql
ãƒªãƒ³ã‚¯
1