CREATE SCHEMA

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

---

NAME

CREATE SCHEMA - å®ä¹ä¸ä¸ªæ°ç模å¼

SYNOPSIS

CREATE SCHEMA schemaname [ AUTHORIZATION username ] [ schema_element [ ... ] ]
CREATE SCHEMA AUTHORIZATION username [ schema_element [ ... ] ]

DESCRIPTION æè¿°

CREATE SCHEMA å°å¨å½åæ°æ®åºéè¾å¥ä¸ä¸ªæ°ç模å¼ã 该模å¼åå°å¨å½åæ°æ®åºéç°åçææ模å¼åä¸å¯ä¸ã

模å¼å®éä¸æ¯ä¸ä¸ªåå空é´ï¼ å®åå«å½å对象ï¼è¡¨ï¼æ°æ®ç±»åï¼å½æ°åæä½ç¬¦ï¼è¿äºååå¯ä»¥åå¶å®æ¨¡å¼éå- å¨çå¶å®å¯¹è±¡éåã å½å对象è¦ä¹æ¯éè¿ç¨æ¨¡å¼åä½ä¸ºåç¼"修饰"è¿äºå®ä»¬çååè¿è¡è®¿é®ï¼ è¦ä¹æ¯éè¿è®¾ç½®ä¸ä¸ªæ索路å¾åå«æéè¦ç模å¼ã æ ä¿®é¥°ç对象é½æ¯å¨å½å模å¼ä¸å建çï¼å¨æ索路å¾æåé¢çï¼å¯ä»¥ç¨å½æ° current_schema æ¥å¤æï¼ã

å¦å¤ï¼CREATE SCHEMA å¯ä»¥åæ¬å¨æ°æ¨¡å¼ä¸å建对象çåå½ä»¤ã è¿äºå- å½ä»¤åé£äºå¨å建å®æ¨¡å¼åååºçå½ä»¤æ²¡æä»»ä½åºå«ï¼åªä¸è¿æ¯å¦æ使ç¨äº AUTHORIZATION åå¥ï¼ é£ä¹ææå建ç对象é½å°è¢«è¯¥ç¨æ·æ¥æã

PARAMETERS åæ°

schemaname

è¦å建ç模å¼ååãå¦æçç¥ï¼å使ç¨ç¨æ·åä½ä¸ºæ¨¡å¼åã

username

å°æ¥æ该模å¼çç¨æ·åãå¦æçç¥ï¼ç¼ºç为æ§è¡è¯¥å½ä»¤çç¨æ·åã åªæè¶çº§ç¨æ·æè½å建ä¸å±äºèªå·±ç模å¼ã

schema_element

ä¸ä¸ª SQL è¯å¥ï¼å®ä¹ä¸ä¸ªè¦å¨æ¨¡å¼éå建ç对象ã ç®åï¼åªæ CREATE TABLEï¼CREATE VIEWï¼ å GRANT æ¯å¨ CREATE SCHEMA éé¢å¯ä»¥æ¥åçåå¥ã å¶å®ç±»åç对象å¯ä»¥å¨å建å®æ¨¡å¼ä¹åçç¬ç«çå½ä»¤éå建ã

NOTES 注æ

è¦å建模å¼ï¼è°ç¨è¯¥å½ä»¤çç¨æ·å¿éå¨å½åæ°æ®åºä¸æ CREATE æéãï¼å½ç¶ï¼è¶çº§ç¨æ·ç»å¼è¿ä¸ªæ£æ¥ãï¼

EXAMPLES ä¾å

å建ä¸ä¸ªæ¨¡å¼ï¼

CREATE SCHEMA myschema;

为ç¨æ· joe åå»ºæ¨¡å¼ --- 模å¼ä¹ä¼å« joeï¼

CREATE SCHEMA AUTHORIZATION joe;

å建ä¸ä¸ªæ¨¡å¼å¹¶ä¸å¨éé¢å建ä¸ä¸ªè¡¨ï¼

CREATE SCHEMA hollywood
CREATE TABLE films (title text, release date, awards text[])
CREATE VIEW winners AS
SELECT title, release FROM films WHERE awards IS NOT NULL;

请注æä¸é¢çç¬ç«çåå½ä»¤ä¸æ¯ç±åå·ç»å°¾çã

ä¸é¢çå½ä»¤æ¯å®ç°åæ ·ç»æççæè¯å¥ï¼

CREATE SCHEMA hollywood;
CREATE TABLE hollywood.films (title text, release date, awards text[]);
CREATE VIEW hollywood.winners AS
SELECT title, release FROM hollywood.films WHERE awards IS NOT NULL;

COMPATIBILITY å¼å®¹æ§

SQL æ ååè®¸å¨ CREATE SCHEMA éé¢æä¸ä¸ª DEFAULT CHARACTER SET å- å¥ï¼ä»¥åæ¯ç®å PostgreSQL å¯ä»¥æ¥åçæ´å¤çåå½ä»¤ã

SQL æ å声æå¨ CREATE SCHEMA éçåå½ä»¤å¯ä»¥ä»¥ä»»æ顺åºåºç°ã ç®å PostgreSQL éçå®ç°è¿ä¸è½å¤çææåå½ä»¤ééè¦æåå¼ç¨çæåµï¼ææ¶åå¯è½éè¦éæä¸ä¸å- å½ä»¤ç顺åºä»¥é¿åååå¼ç¨ã

å¨ SQL æ åéï¼æ¨¡å¼çææèæ»æ¯æ¥æå¶ä¸çææ对象ã PostgreSQL å许模å¼åå«é模å¼ææèææç对象ã åªæå¨æ¨¡å¼ææè CREATE äºèªå·±ç模å¼çæéç»äºå¶å®äººæå¯è½åºç°ã

SEE ALSO åè§

ALTER SCHEMA [alter_schema(7)], DROP SCHEMA [drop_schema(l)]

è¯è

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

è·

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

---