ALTER TABLE

中文man手册

ALTER TABLE

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

NAME

ALTER TABLE - ä¿®æ¹è¡¨çå®ä¹

SYNOPSIS

ALTER TABLE [ ONLY ] name [ * ]
ADD [ COLUMN ] column type [ column_constraint [ ... ] ]
ALTER TABLE [ ONLY ] name [ * ]
DROP [ COLUMN ] column [ RESTRICT | CASCADE ]
ALTER TABLE [ ONLY ] name [ * ]
ALTER [ COLUMN ] column { SET DEFAULT expression | DROP DEFAULT }
ALTER TABLE [ ONLY ] name [ * ]
ALTER [ COLUMN ] column { SET | DROP } NOT NULL
ALTER TABLE [ ONLY ] name [ * ]
ALTER [ COLUMN ] column SET STATISTICS integer
ALTER TABLE [ ONLY ] name [ * ]
ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
ALTER TABLE [ ONLY ] name [ * ]
SET WITHOUT OIDS
ALTER TABLE [ ONLY ] name [ * ]
RENAME [ COLUMN ] column TO new_column
ALTER TABLE name
RENAME TO new_name
ALTER TABLE [ ONLY ] name [ * ]
ADD table_constraint
ALTER TABLE [ ONLY ] name [ * ]
DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]
ALTER TABLE name
OWNER TO new_owner
ALTER TABLE name
CLUSTER ON index_name

DESCRIPTION æè¿°

ALTER TABLE åæ´ä¸ä¸ªç°åè¡¨çå®ä¹ãå®æå¥½å ç§åå½¢å¼ï¼
ADD COLUMN

è¿ç§å½¢å¼ç¨å CREATE TABLE [create_table(7)] éä¸æ ·çè¯æ³åè¡¨ä¸- å¢å ä¸ä¸ªæ°çåæ®µã

DROP COLUMN

SET/DROP DEFAULT

SET/DROP NOT NULL

SET STATISTICS

This form
è¿ä¸ªå½¢å¼ä¸ºéåç ANALYZE [analyze(7)] æä½è®¾ç½®æ¯å- æ®µçç»è®¡æ¶éç®æ ã ç®æ çèå´å¯ä»¥å¨ 0 å° 1000 ä¹åè®¾ç½®ï¼å¦å¤ï¼æä»è®¾ç½®ä¸º -1 åè¡¨ç¤ºéæ°æ¢å¤å°ä½¿ç¨ç³»ç»ç¼ºççç»è®¡ç®æ ã

SET STORAGE

SET WITHOUT OIDS

RENAME

ADD table_constraint

è¿ä¸ªå½¢å¼ç»è¡¨å¢å ä¸ä¸ªæ°ççº¦æï¼ç¨çè¯æ³å CREATE TABLE [create_table(7)] ä¸æ ·ã

DROP CONSTRAINT

OWNER

è¿ä¸ªå½¢å¼æ¹åè¡¨ï¼ç´¢å¼ï¼åºåæèè§å¾çææèä¸ºæå®ææèã

CLUSTER

è¿ç§å½¢å¼ä¸ºå°æ¥å¯¹è¡¨è¿è¡ç CLUSTER [cluster(7)] æä½åæ è®°ã

PARAMETERS åæ°

name

column

ç°åææ°çåæ®µåç§°ã

type

æ°åæ®µçç±»åã

new_column

æ°åæ®µçç±»åã

new_name

è¡¨çæ°åç§°ã

table_constraint

è¡¨çæ°ççº¦æå®ä¹ã

constraint_name

è¦å é¤çç°æçº¦æçååã

new_owner

è¯¥è¡¨çæ°ææèçç¨æ·åã

index_name

è¦æ è®°ä¸ºå»ºç°çè¡¨ä¸é¢çç´¢å¼ååã

CASCADE

RESTRICT

NOTES æ³¨æ

COLUMN å³é®åæ¯å¤ä½çï¼å¯ä»¥çç¥ã

å¨ç®åç ADD COLUMNå®ç°éè¿ä¸æ¯ææ°å/åæ®µçç¼ºçï¼å¼ï¼å NOT NULL åå¥ã æ°å- æ®µå¼å§åå¨æ¶ææå¼é½æ¯ NULLã ä¸è¿ä½ å¯ä»¥éåç¨ ALTER TABLE ç SET DEFAULT å½¢å¼è®¾ç½®ç¼ºçï¼å¼ï¼ãï¼ä½ å¯è½è¿æ³ç¨ UPDATE [update(7)] æå·²å- å¨è¡æ´æ°ä¸ºç¼ºçå¼ãï¼ å¦æä½ æ³æ è®°è¯¥åæ®µä¸ºé nullï¼å¨ä½ ä¸ºè¯¥å- æ®µçææè¡è¾å¥é null å¼ä¹åç¨ SET NOT NULLã

UPDATE table SET col = col;
VACUUM FULL table;

ä¸åè®¸æ´æ¹ç³»ç»è¡¨ç»æçä»»ä½é¨åã

è¯·åèCREATE TABLE é¨åè·åæ´å¤ææåæ°çæè¿°ã Chapter 5 ‘‘Data Definition’’ éææ´å¤æå³ç»§æ¿çä¿¡æ¯ã

EXAMPLES ä¾å

åè¡¨ä¸å¢å ä¸ä¸ª varchar åï¼

ALTER TABLE distributors ADD COLUMN address varchar(30);

ä»è¡¨ä¸å é¤ä¸ä¸ªåæ®µï¼

ALTER TABLE distributors DROP COLUMN address RESTRICT;

å¯¹ç°ååæ¹åï¼

ALTER TABLE distributors RENAME COLUMN address TO city;

æ´æ¹ç°åè¡¨çååâ¶

ALTER TABLE distributors RENAME TO suppliers;

ALTER TABLE distributors ALTER COLUMN street SET NOT NULL;

ALTER TABLE distributors ALTER COLUMN street DROP NOT NULL;

ç»ä¸ä¸ªè¡¨å¢å ä¸ä¸ªæ£æ¥çº¦æï¼

ALTER TABLE distributors ADD CONSTRAINT zipchk CHECK (char_length(zipcode) = 5);

å é¤ä¸ä¸ªè¡¨åå®çææåè¡¨ççæ¥çº¦æï¼

ALTER TABLE distributors DROP CONSTRAINT zipchk;

åè¡¨ä¸å¢å ä¸ä¸ªå¤é®çº¦æï¼

ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (address) REFERENCES addresses (address) MATCH FULL;

ç»è¡¨å¢å ä¸ä¸ªï¼å¤åæ®µï¼å¯ä¸çº¦æï¼

ALTER TABLE distributors ADD CONSTRAINT dist_id_zipcode_key UNIQUE (dist_id, zipcode);

ALTER TABLE distributors ADD PRIMARY KEY (dist_id);

COMPATIBILITY å¼å®¹æ§

ADD COLUMN å½¢å¼æ¯å¼å®¹ SQL æ åçï¼ é¤äºä¸é¢è¯´çç¼ºçï¼å¼ï¼å NOT NULL çº¦æå¤ã ALTER COLUMN å½¢å¼æ¯å®å¨å¼å®¹çã

è¯è

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

è·

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

手册导航

man1

man2

man3

man4

man5

man6

man7

man8

ALTER TABLE

目录

ALTER TABLE

NAME

SYNOPSIS

DESCRIPTION æè¿°

PARAMETERS åæ°

NOTES æ³¨æ

EXAMPLES ä¾å

COMPATIBILITY å¼å®¹æ§

è¯è

è·