CREATE DATABASE

中文man手册

目录

NAME CREATE DATABASE
SYNOPSIS .sp .nf CREATE DATABASE
DESCRIPTION 描述
PARAMETERS 参数
NOTES 注意
EXAMPLES 例子
COMPATIBILITY 兼容性
译者
跋

CREATE DATABASE

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

NAME

CREATE DATABASE - åå»ºæ°æ°æ®åº

SYNOPSIS

CREATE DATABASE name
[ [ WITH ] [ OWNER [=] dbowner ]
[ LOCATION [=] ’dbpath’ ]
[ TEMPLATE [=] template ]
[ ENCODING [=] encoding ] ]

DESCRIPTION æè¿°

CREATE DATABASE åå»ºä¸ä¸ªæ°ç PostgreSQL æ°æ®åºã

è¦åå»ºä¸ä¸ªæ°æ®åºï¼ä½ å¿é¡»æ¯ä¸ä¸ªè¶çº§ç¨æ·æèæç¹æ®ç CREATEDB æéã åé CREATE USER [create_user(7)]ã

éå¸¸ï¼åå»ºèæä¸ºæ°æ°æ®åºçç®¡çåã è¶çº§ç¨æ·å¯ä»¥ç¨ OWNER å- å¥åå»ºå¶å®ç¨æ·ææçæ°æ®åºã ä»ä»¬çè³å¯ä»¥åå»ºæ²¡æç¹æ®æéçç¨æ·ææçæ°æ®åºã æCREATEDBæéçéè¶çº§ç¨æ·ä½¿ç¨åªè½åå»ºèªå·±ä½¿ç¨çæ°æ®åºã

å¯ä»¥å£°æä¸ä¸ªå¯éçæ°æ®åºä½ç½®ï¼ä¾å¦ï¼å¨å¦ä¸åç¡¬çä¸åæ¾æ°æ®åºã è¯¥è·¯å¾å¿é¡»æ¯äºåç¨ initlocation[initlocation(1)] å½ä»¤åå¤å¥½äºçã

å¦æè·¯å¾åä¸åå«ææ ï¼é£ä¹å®è¢«è§£éæä¸ä¸ªç¯å¢åéï¼ è¯¥åéå¿é¡»ä¸ºæå¡è¿ç¨æç¥ãè¿æ ·æ°æ®åºç®¡çå å¯ä»¥å¯¹è½å¤å¨é£éåå»ºæ°æ®åºè¿è¡æ§å¶ãï¼ä¾å¦ï¼ä¸ä¸ªç¨æ·åçéæ©æ¯ ’PGDATA2’ãï¼å¦ææå¡å¨å¸¦ç ALLOW_ABSOLUTE_DBPATHS ï¼ç¼ºçæ¶æ²¡æï¼éé¡¹ç¼è¯ï¼ é£ä¹ä¹åè®¸ä½¿ç¨ä»¥ææ å¼å¤´ä¸ºæ è¯çç»å¯¹è·¯å¾ï¼ä¾å¦ï¼ ’ ’/usr/local/pgsql/data’ï¼ã In either case, the final path name must be absolute and must not contain any single quotes.

ç¼ºçæ¶ï¼æ°æ°æ®åºå°éè¿åéæ åç³»ç»æ°æ®åº template1 æ¥åå»ºãä¸åçæ¨¡æ¿å¯ä»¥ç¨ TEMPLATE = name æ¥åãå°¤å¶æ¯ï¼å¦æä½ ç¨ TEMPLATE = template0ï¼ ä½ å¯ä»¥åå»ºä¸ä¸ªå¾çº¯åçæ°æ®åºï¼åªåæ¬ä½ ççæ¬ç PostgreSQL é¢å®ä¹ç æ åå¯¹è±¡ãè¿ä¸ªæ¹æ³å¯ä»¥é¿åæä»»ä½å·²ç»å å¥å°template1 éçæ¬å°å®è£å¯¹è±¡æ·è´å°æ°æ°æ®åºã

å¯éçç¼ç åæ°åè®¸éæ©æ°æ®åºç¼ç ï¼ å¦ææ²¡æå£°æï¼ç¼ºçæ¯æéç¨çæ¨¡æ¿æ°æ®åºç¨çç¼ç ã

PARAMETERS åæ°

name

è¦åå»ºçæ°æ®åºåã

dbowner

æ°æ®åºç¨æ·çååï¼ä»å°æ¥ææ°æ°æ®åºï¼æèæ¯å DEFAULT ä½¿ç¨ç¼ºççï¼ä¹å°±æ¯æ§è¡å½ä»¤çç¨æ·ï¼ã

dbpath

å¨æä»¶ç³»ç»éåå¨æ°æ°æ®åºçå¯éä½ç½®ï¼ç¨åä¸²ææ¬å£°æã æèç¨ DEFAULT è¡¨ç¤ºä½¿ç¨ç¼ºçä½ç½®ã

template

ä»åªä¸ªæ¨¡æ¿åå»ºæ°æ°æ®åºï¼è¿æ¯æ¨¡æ¿åãæèç¨ DEFAULT ä½¿ç¨ç¼ºçæ¨¡æ¿ï¼template1ï¼ã

encoding

åå»ºæ°æ°æ®åºç¨çå¤åèç¼ç æ¹æ³ãå£°æä¸ä¸ªåä¸²ææ¬åå ï¼æ¯å¦ï¼’SQL_ASCII’ï¼ï¼ æèä¸ä¸ªæ´æ°ç¼å·ï¼æèæ¯ DEFAULT è¡¨ç¤ºä½¿ç¨ç¼ºçç¼ç ã

å¯éåæ°å¯ä»¥ä»¥ä»»æé¡ºåºåï¼èä¸ä»æ¯ä¸é¢æ¾ç¤ºçé¡ºåºã

NOTES æ³¨æ

CREATE DATABASE ä¸è½å¨ä¸ä¸ªäºå¡åéé¢æ§è¡ã block.

ç±»ä¼¼ "could not initialize database directory" è¿æ ·çéè¯¯ææå¯è½æ¯å ä¸ºæ°æ®ç®å½çæéä¸å¤ï¼ æèç£çæ»¡ï¼æèå¶å®æä»¶ç³»ç»çé®é¢ãå¨ä½¿ç¨å¯éçä½ç½®çæ¶åï¼è¿è¡æ°æ®åºæå¡å¨çç¨æ·å¿é¡»æè®¿é®è¯¥ä½ç½®çæéã

ä½¿ç¨ DROP DATABASE [drop_database(7)] å é¤ä¸ä¸ªæ°æ®åºã

ç¨åº createdb[createdb(1)] æ¯æ¯è¿ä¸ªå½ä»¤çå°è£ï¼æä¾æ¥æ¹ä¾¿ä½¿ç¨ã

å¨ç¨ç»å¯¹è·¯å¾æå®çå¯éæ°æ®åºä½ç½®æ¶ï¼æä¸äºå®å¨åæ°æ®å®æ´æ§çé®é¢ï¼ è¿å°±æ¯ä¸ºä»ä¹ç¼ºçæ¶æ²¡ææå¼è¿ä¸ªç¹æ§çåå ã åè ‘‘Managing Databases’’ è·åæ´å¤çä¿¡æ¯ã

å°½ç®¡æä»¬å¯ä»¥éè¿æææ°æ®åºåå£°æä¸ºæ¨¡æ¿ï¼èé template1ï¼ä»étemplate1æ°æ®åºæ·è´æ°æ®åºï¼ ä½æ¯è¿ï¼è¿ï¼ä¸æ¯ä¸ä¸ªéç¨ç "COPY DATABASE" åè½ã å æ- ¤ï¼æä»¬å»ºè®®å½åæ¨¡æ¿ä½¿ç¨çæ°æ®åºé½åºè¯¥æ¯ä»¥åªè¯»æ¹å¼å¯¹å¾çã åé ‘‘Managing Databases’’ è·åæ´å¤ä¿¡æ¯ã

EXAMPLES ä¾å

åå»ºä¸ä¸ªæ°çæ°æ®åºï¼

CREATE DATABASE lusiadas;

å¨å¦ä¸ä¸ªå°æ¹ ˜/private_dbåå»ºæ°æ°æ®åºï¼ å¨ shell éæ§è¡ä¸é¢çä¸è¥¿ï¼ shell:

mkdir private_db
initlocation ˜/private_db

ç¶åå¨ä¸ä¸ª psql ä¼è¯éæ§è¡ä¸é¢çä¸è¥¿ï¼

CREATE DATABASE elsewhere WITH LOCATION ’/home/olly/private_db’;

COMPATIBILITY å¼å®¹æ§

å¨ SQL æ åéæ²¡æ CREATE DATABASE è¯å¥ã æ°æ®åºç- åäºç®å½ï¼å¶åå»ºæ¯ç±å®ç°å³å®çã

è¯è

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

è·

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

↑