CREATEDB
目录
CREATEDB
NAMESYNOPSIS
DESCRIPTION æè¿°
OPTIONS é项
ENVIRONMENT ç¯å¢
DIAGNOSTICS è¯æ
EXAMPLES ä¾å
SEE ALSO åè§
è¯è
è·
NAME
createdb - å建ä¸ä¸ªæ°ç PostgreSQL æ°æ®åº
SYNOPSIS
createdb [ option... ] [ dbname ] [ description ]
DESCRIPTION æè¿°
createdb å建ä¸ä¸ªæ°ç PostgreSQL æ°æ®åºã
é常ï¼æ§è¡è¿ä¸ªå½ä»¤çæ°æ®åºç¨æ·æ为æ°æ°æ®åºçææèã ä¸è¿ï¼å¦ææ§è¡ç¨æ·æ¥æåéçæéï¼é£ä¹ä»å¯ä»¥éè¿ -O æå®åéçç¨æ·ã
createdb æ¯ä¸ä¸ª SQL å½ä»¤ CREATE DATABASE [create_database(7)] çå°è£ã å æ¤ï¼ç¨åªç§æ¹æ³å建æ°æ®åºé½æ²¡ä»ä¹ç¹å«çã
OPTIONS é项
createdb æ¥åä¸åå½ä»¤è¡åæ°ï¼
|
dbname |
声æè¦å建çæ°æ®åºåã该å称åºè¯¥å¨æ¬èç¹ç PostgreSQL æææ°æ®åºéé¢æ¯å¯ä¸çã 缺çæ¯ä¸å½åç³»ç»ç¨æ·ååã
description
è¿ä¸ªé项声æä¸ä¸ªä¸æ°å建çæ°æ®åºç¸å³ç注解ã
-D location
--location location
声æåæ´äºçæ°æ®åºé群ï¼èç¹ï¼çä½ç½®ã åè§ initlocation(1).
|
-e |
||
|
--echo |
åæ¾ createdb çæçå½ä»¤å¹¶ä¸æå®åéå°æå¡å¨ã
-E encoding
--encoding encoding
声æç¨äºæ¤æ°æ®åºçå符ç¼ç æ¹å¼ã
-O owner
--owner owner
æå®å°æ¥ææ°æ°æ®åºçæ°æ®åºç¨æ·ã
|
-q |
--quiet
ä¸æ¾ç¤ºååºã
-T template
--template template
声æå建æ¤æ°æ®åºç模æ¿æ°æ®åºã
é项 -hï¼-pï¼-Uï¼ -Wï¼-e æ¯ä»¥ææ¬å½¢å¼ä¼ éç» psqlã é项-Oï¼-Dï¼-T å -E 转æ¢ä¸ºä¸å±ç SQL å½ä»¤ CREATE DATABASE [create_database(7)] çé项ï¼åè该æ¡ç®è·åæ´å¤ç¸å³ä¿¡æ¯ã
createdb
è¿æ¥åä¸åå½ä»¤è¡åæ°ä½ä¸ºè¿æ¥åæ°ï¼
-h host
--host host
声æè¿è¡æå¡å¨ç主æºåã å¦ææ°å¼ä»¥ææå¼å¤´ï¼åå®è¢«ç¨åå° Unix åå¥æ¥åçè·¯å¾ã
-p port
--port port
声ææå¡å¨ 侦å¬ççå¾è¿æ¥çäºèç½ TCP 端å£æä¸ä¸ªæ¬å° Unix åå¥æ¥å- æ件æ©å±ï¼æ述符ï¼ã
-U username
--username username
è¿è¡èæ¥çç¨æ·åã
|
-W |
--password
强å¶å£ä»¤æ示符ã
ENVIRONMENT ç¯å¢
PGDATABASE
å¦æ设置äºï¼é£ä¹å°±æ¯è¦å建çæ°æ®åºååï¼é¤éå¨å½ä»¤è¡ä¸è¦çäºã
|
PGHOST |
||
|
PGPORT |
||
|
PGUSER |
缺çè¿æ¥åæ°ãPGUSER è¿å³å®äºè¦å建çæ°æ®åºååï¼ï¼ å¦ææ们没æå¨å½ä»¤è¡ä¸å£°ææ°æ®åºååï¼ä¹æ²¡æç¨ PGDATABASE 声æçè¯ã
DIAGNOSTICS è¯æ
å¦æåºç°é误ï¼å°ä¼æ¾ç¤ºå端é误信æ¯ãåé CREATE DATABASE [create_database(7)] å psql(1) è·åå¯è½ä¿¡æ¯æè¿°ã æ°æ®åºæå¡å¨å¿é¡»å¨ç®æ æå¡å¨ä¸è¿è¡ãåæ ·ï¼åç«¯åº libpq 使ç¨ç缺çè¿æ¥è®¾ç½®åç¯å¢åéé½å°éç¨ã
EXAMPLES ä¾å
ç¨ç¼ºçæ°æ®åºæå¡å¨å建ä¸ä¸ªæ°æ®åº demoï¼
$ createdb
demo
CREATE DATABASE
ååºä¿¡æ¯ä¸è¿è¡ CREATE DATABASE SQL å½ä»¤æ¶ä¸æ ·ã
ç¨å¨ä¸»æºedenä¸çæå¡å¨å建æ°æ®åº demoï¼ ç«¯å£æ¯ 5000ï¼ä½¿ç¨ LATIN1 ç¼ç æ¹å¼ï¼å¹¶ä¸æ¾ç¤ºæ§è¡çå½ä»¤ï¼
$ createdb -p
5000 -h eden -E LATIN1 -e demo
CREATE DATABASE "demo" WITH ENCODING =
’LATIN1’
CREATE DATABASE
SEE ALSO åè§
dropdb(1), CREATE DATABASE [create_database(7)]
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh