CREATE TABLE

中文man手册

CREATE TABLE

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES æ³¨æ
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
TEMPORARY TABLES ä¸´æ¶è¡¨
COLUMN CHECK CONSTRAINTS åæ®µæ£æ¥çº¦æ
NULL ‘‘CONSTRAINT’’ NULLçº¦æ
INHERITANCE ç»§æ¿
OBJECT IDS å¯¹è±¡ID
ZERO-COLUMN TABLES é¶è¡è¡¨
SEE ALSO åè§
è¯è
è·

NAME

CREATE TABLE - å®ä¹ä¸ä¸ªæ°è¡¨

SYNOPSIS

CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
{ column_name data_type [ DEFAULT default_expr ] [ column_constraint [, ... ] ]
| table_constraint
| LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] } [, ... ]
)
[ INHERITS ( parent_table [, ... ] ) ]
[ WITH OIDS | WITHOUT OIDS ]
[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]

where column_constraint is:

[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | UNIQUE | PRIMARY KEY |
CHECK (expression) |
REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]
[ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

and table_constraint is:

[ CONSTRAINT constraint_name ]
{ UNIQUE ( column_name [, ... ] ) |
PRIMARY KEY ( column_name [, ... ] ) |
CHECK ( expression ) |
FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]
[ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

DESCRIPTION æè¿°

PARAMETERS åæ°

TEMPORARY æ TEMP

æä»¬å¯ä»¥éæ©å¨ TEMPORARY æ TEMP åé¢æ¾ä¸ GLOBAL æè LOCALã è¿æ ·å¯¹ PostgreSQL æ²¡æä»»ä½åºå«ï¼å¯ä»¥åé Compatibility [create_table(7)]ã

table_name

è¦åå»ºçè¡¨çååï¼å¯ä»¥ç¨æ¨¡å¼ä¿®é¥°ï¼ã

column_name

å¨æ°è¡¨ä¸è¦åå»ºçåæ®µååã

data_type

è¯¥åæ®µçæ°æ®ç±»åãå®å¯ä»¥åæ¬æ°ç»è¯´æç¬¦ã

DEFAULT

INHERITS ( parent_table [, ... ] )

WITH OIDS
WITHOUT OIDS

CONSTRAINT constraint_name

åæè¡¨çº¦æçå¯éååãå¦ææ²¡æå£°æï¼åç±ç³»ç»çæä¸ä¸ªååã

NOT NULL

åæ®µä¸åè®¸åå« NULL æ°å¼ã

NULL

è¯¥åæ®µåè®¸åå« NULL æ°å¼ãè¿æ¯ç¼ºçã

UNIQUE (column constraint)
UNIQUE ( column_name [, ... ] ) (table constraint)

PRIMARY KEY (column constraint)
PRIMARY KEY ( column_name [, ... ] ) (table constraint)

CHECK (expression)

REFERENCES reftable [ ( refcolumn ) ] [ MATCH matchtype ] [ ON DELETE
action ] [ ON UPDATE action ] (column constraint)
FOREIGN KEY ( column [, ... ] )

åè¿äºåæ®µæå¥çæ°å¼å°ä½¿ç¨ç»åºçå¹éç±»åä¸åèè¡¨ä¸çåèåä¸- çæ°å¼è¿è¡å¹éã æä¸ç§å¹éç±»åï¼MATCH FULLï¼ MATCH PARTIALï¼å MATCH SIMPLEï¼å®ä¹æ¯ç¼ºçå¹éç±»åã MATCH FULL å°ä¸åè®¸ä¸ä¸ªå¤åæ®µå¤é®çå- æ®µä¸º NULLï¼é¤éææå¤é®åæ®µé½ä¸º NULLã MATCH SIMPLE åè®¸æäºå¤é®å- æ®µä¸º NULL èå¤é®çå¶å®é¨åä¸æ¯ NULLãMATCH PARTIAL è¿æ²¡å®ç°ã

RESTRICT

CASCADE

SET NULL

æå¼ç¨è¡æ°å¼è®¾ç½®ä¸º NULLã

SET DEFAULT

æå¼ç¨åçæ°å¼è®¾ç½®ä¸ºå®ä»¬çç¼ºçå¼ã

å¦æä¸»é®åæ®µç»å¸¸æ´æ°ï¼é£ä¹æä»¬ç» REFERENCES å- æ®µå¢å ä¸ä¸ªç´¢å¼å¯è½æ¯åéçï¼è¿æ ·ä¸ REFERENCES åæ®µç¸å³èç NO ACTION å CASCADE å¨ä½å¯ä»¥æ´ææå°æ§è¡ã
DEFERRABLE
NOT DEFERRABLE

INITIALLY IMMEDIATE
INITIALLY DEFERRED

ON COMMIT

å¨äºå¡ç»å°¾ä¸åçä»»ä½ç¹å®çå¨ä½ãè¿æ¯ç¼ºçè¡ä¸ºã

DELETE ROWS

DROP

å¨å½åäºå¡åçç»å°¾ï¼ä¸´æ¶è¡¨å°è¢«å é¤ã

NOTES æ³¨æ

•

	•		PostgreSQL èªå¨ä¸ºæ¯ä¸ªå¯ä¸çº¦æåä¸»é®çº¦æåå»ºä¸ä¸ªç´¢å¼ä»¥ç¡®ä¿å¯ä¸æ§ã å æ- ¤ï¼æä»¬ä¸å¿ä¸ºä¸»é®åæ®µåå»ºæç¡®çç´¢å¼ãï¼åé CREATE INDEX [create_index(7)]è·åæ´å¤ä¿¡æ¯ãï¼
	•

EXAMPLES ä¾å

åå»ºè¡¨ films å distributorsï¼

CREATE TABLE films (
code char(5) CONSTRAINT firstkey PRIMARY KEY,
title varchar(40) NOT NULL,
did integer NOT NULL,
date_prod date,
kind varchar(10),
len interval hour to minute
);

CREATE TABLE distributors (
did integer PRIMARY KEY DEFAULT nextval(’serial’),
name varchar(40) NOT NULL CHECK (name <> ’’)
);

åå»ºä¸ä¸ªå¸¦æ 2 ç»´æ°ç»çè¡¨ï¼

CREATE TABLE array (
vector int[][]
);

CREATE TABLE films (
code char(5),
title varchar(40),
did integer,
date_prod date,
kind varchar(10),
len interval hour to minute,
CONSTRAINT production UNIQUE(date_prod)
);

å®ä¹ä¸ä¸ªæ£æ¥åçº¦æï¼

CREATE TABLE distributors (
did integer CHECK (did > 100),
name varchar(40)
);

å®ä¹ä¸ä¸ªæ£æ¥è¡¨çº¦æï¼

CREATE TABLE distributors (
did integer,
name varchar(40)
CONSTRAINT con1 CHECK (did > 100 AND name <> ’’)
);

CREATE TABLE films (
code char(5),
title varchar(40),
did integer,
date_prod date,
kind varchar(10),
len interval hour to minute,
CONSTRAINT code_title PRIMARY KEY(code,title)
);

CREATE TABLE distributors (
did integer,
name varchar(40),
PRIMARY KEY(did)
);

CREATE TABLE distributors (
did integer PRIMARY KEY,
name varchar(40)
);

CREATE TABLE distributors (
name varchar(40) DEFAULT ’Luso Films’,
did integer DEFAULT nextval(’distributors_serial’),
modtime timestamp DEFAULT current_timestamp
);

CREATE TABLE distributors (
did integer CONSTRAINT no_null NOT NULL,
name varchar(40) NOT NULL
);

ä¸º name åæ®µå®ä¹ä¸ä¸ªå¯ä¸çº¦æï¼

CREATE TABLE distributors (
did integer,
name varchar(40) UNIQUE
);

ä¸é¢çåä¸é¢è¿æ ·ä½ä¸ºä¸ä¸ªè¡¨çº¦æå£°ææ¯ä¸æ ·çï¼

CREATE TABLE distributors (
did integer,
name varchar(40),
UNIQUE(name)
);

COMPATIBILITY å¼å®¹æ§

CREATE TABLE éµå¾ª SQL92 å SQL99 çä¸ä¸ªåéï¼ä¸äºä¾å¤æåµå¨ä¸é¢ååºã

TEMPORARY TABLES ä¸´æ¶è¡¨

ä¸´æ¶è¡¨ç ON COMMIT åå¥ä¹ç±»ä¼¼äº SQL æ åï¼ ä½æ¯æäºåºå«ãå¦æå¿½ç¥äº ON COMMIT åå¥ï¼SQL å£°æç¼ºççè¡ä¸ºæ¯ ON COMMIT DELETE ROWSã ä½æ¯ PostgreSQL éçç¼ºçè¡ä¸ºæ¯ ON COMMIT PRESERVE ROWSã å¨ SQL éä¸åå¨ ON COMMIT DROPã

COLUMN CHECK CONSTRAINTS åæ®µæ£æ¥çº¦æ

NULL ‘‘CONSTRAINT’’ NULLçº¦æ

INHERITANCE ç»§æ¿

éè¿ INHERITS åå¥çå¤éç»§æ¿æ¯ PostgreSQL è¯è¨çæ©å±ã SQL99ï¼ä½ä¸åæ¬ SQL92ï¼ä½¿ç¨ä¸åçè¯æ³åè¯ä¹å®ä¹äºåç»§æ¿ã SQL99 é£æ ¼çç»§æ¿è¿æ²¡æå¨ PostgreSQL ä¸å®ç°ã

OBJECT IDS å¯¹è±¡ID

PostgreSQL ç OID çæ¦å¿µä¸æ åã

ZERO-COLUMN TABLES é¶è¡è¡¨

è¯è

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

è·

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

手册导航

man1

man2

man3

man4

man5

man6

man7

man8

CREATE TABLE

目录

CREATE TABLE

NAME

SYNOPSIS

DESCRIPTION æè¿°

PARAMETERS åæ°

NOTES æ³¨æ

EXAMPLES ä¾å

COMPATIBILITY å¼å®¹æ§

TEMPORARY TABLES ä¸´æ¶è¡¨

COLUMN CHECK CONSTRAINTS åæ®µæ£æ¥çº¦æ

NULL ‘‘CONSTRAINT’’ NULLçº¦æ

INHERITANCE ç»§æ¿

OBJECT IDS å¯¹è±¡ID

ZERO-COLUMN TABLES é¶è¡è¡¨

SEE ALSO åè§

è¯è

è·