ALTER DATABASE

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES 注æ
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·

---

NAME

ALTER DATABASE - ä¿®æ¹ä¸ä¸ªæ°æ®åº

SYNOPSIS

ALTER DATABASE name SET parameter { TO | = } { value | DEFAULT }
ALTER DATABASE name RESET parameter

ALTER DATABASE name RENAME TO newname

DESCRIPTION æè¿°

ALTER DATABASE ç¨äºæ¹åä¸ä¸ªæ°æ®åºçå±æ§ã

头两ç§å½¢å¼ä¸º PostgreSQL æ°æ®åºä¿®æ¹ç¼ºççä¼è¯è¿è¡æ¶éç½®åéã éåå¨è¯¥æ°æ®åºä¸å¯å¨ä¸ä¸ªæ°çä¼è¯çæ¶åï¼ å¨å¯å¨ä¼è¯ä¹ååææå°è¿è¡ SET variable TO valueã æ°æ®åºç¸å³ç缺çå¼è¦çä»»ä½å¨ postgresql.conf éåºç°æèä» postmaster å½ä»¤è¡æ¥æ¶å°ç设置ã åªææ°æ®åºææèæèè¶çº§ç¨æ·å¯ä»¥ä¸ºä¸ä¸ªæ°æ®åºä¿®æ¹ä¼è¯ç¼ºçã

第ä¸ç§å½¢å¼ä¿®æ¹è¯¥æ°æ®åºçå称ãåªææ°æ®åºææèå¯ä»¥éå½åä¸ä¸ªæ°æ®åºï¼å¹¶ä¸åªæå¨ä»æ CREATEDB æéçæ¶åå¯ä»¥ã å½åçæ°æ®åºä¸è½è¢«éå½åãï¼å¦æä½ éè¦è¿ä¹åï¼é£ä¹è¿æ¥å¦å¤ä¸ä¸ªæ°æ®åºãï¼

PARAMETERS åæ°

name

éè¦ä¿®æ¹ä¼è¯ç¼ºççæ°æ®åºçååã

parameter

value

ææå®çæ°æ®åºéç½®åéçä¼è¯ç¼ºçå¼è®¾ç½®ä¸ºç»åºçæ°å¼ã å¦æ value 使ç¨äº DEFAULT æèæ¯çæç RESETï¼ é£ä¹ä¸æ°æ®åºç¸å³çåé设置å°è¢«å é¤å¹¶ä¸å¨æ°çä¼è¯ä¸- å°ç»§æ¿ç¼ºç设置ã ç¨ RESET ALL æ¸é¤ææ设置ã

åé SET [set(7)] å Section 16.4 ‘‘Run-time Configuration’’ è·åæå³å许çåéååæ°å¼ç æ´å¤ä¿¡æ¯ã

newname

æ°æ®åºçæ°ååã

NOTES 注æ

ä½¿ç¨ ALTER USER [alter_user(7)]ï¼ æ们ä¹å¯ä»¥æä¸ä¸ªä¼è¯ç¼ºçç»å®å°ä¸ä¸ªç¹å®ç¨æ·ï¼èä¸æ¯æ个æ°æ®åºä¸ã å¦æå- å¨å²çªï¼é£ä¹ç¨æ·å£°æç设置è¦çæ°æ®åºç¸å³ç设置ã

EXAMPLES ä¾å

è¦å³éå¨æ°æ®åº test ä¸ç¼ºççç´¢å¼ä½¿ç¨â¶

ALTER DATABASE test SET enable_indexscan TO off;

COMPATIBILITY å¼å®¹æ§

ALTER DATABASE è¯å¥æ¯ä¸ä¸ª PostgreSQL æ©å±ã

SEE ALSO åè§

ALTER USER [alter_user(7)], CREATE DATABASE [create_database(l)], DROP DATABASE [drop_database(l)], SET [set(l)]

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æå页计åæä¾ã
ä¸æ man æå页计åï¼https://github.com/man-pages-zh/manpages-zh

---