PostgreSQL 8.2.3 婺桺桺懼
劯锔媆锔媆誕嬉誕

ALTER INDEX

劉䓄

ALTER INDEX -- 櫹埻婔婻䘵嚘䔇垔幬

臺濘

ALTER INDEX name RENAME TO new_name
ALTER INDEX name SET TABLESPACE tablespace_name
ALTER INDEX name SET ( storage_parameter = value [, ... ] )
ALTER INDEX name RESET ( storage_parameter [, ... ] )

柟誄

ALTER INDEX 櫹埻婔婻䯄橬䘵嚘䔇垔幬㔗垄橬庹䓉床嘵嚟

RENAME

埻櫹埻䘵嚘䔇劉庖㔗凹庻嗘䔇昄扞澇橬嘌巉㔗

SET TABLESPACE

櫹埻䘵嚘䔇臘䷺閘婺毺垔臘䷺閘幽婫檪䘵嚘䕩噿䔇昄扞桺傽䓂媘彄桄䔇臘䷺閘麯㔗埽蓕 CREATE TABLESPACE

SET ( storage_parameter = value [, ... ] )

櫹埻䘵嚘䔇婔婻潡崔婻䘵嚘桹濘䬹垔䔇庻嗘埗昄㔗埗蓕 CREATE INDEX 诙埡埇䫘埗昄䔇䂖誗㔗驔襕濘懟䔇滇䘵嚘喙垹婉嚔赆認婻变傴䆋剿媞櫹湹扞埗昄䔇婉劯嘹埇脘驔襕嘪䫘 REINDEX 麉傺䘵嚘準诙冖橘橕䔇昽悩㔗

RESET ( storage_parameter [, ... ] )

麉䘞䘵嚘䔇婔婻潡崔婻䘵嚘桹濘䬹垔䔇庻嗘埗昄婺䚺䩕唚㔗婯 SET 婔湙埇脘驔襕嘪䫘 REINDEX 準垯噘敘桄䘵嚘㔗

埗昄

name

襕媞櫹䔇䘵嚘䔇劉庖(埇傖橬昇嚟媞閄)

new_name

䘵嚘䔇桄劉庖

tablespace_name

䘵嚘儖䓂媘彄䔇臘䷺閘䔇劉庖

storage_parameter

䘵嚘桹濘䬹垔䔇庻嗘埗昄䔇劉庖

value

䘵嚘桹濘䬹垔䔇庻嗘埗昄䔇桄唚㔗湹扞埗昄䔇婉劯認埇脘滇婔婻昄庖潡剘臉㔗

濘懟

認底淉嘩幘埇傖䫘 ALTER TABLE 誕臯㔗ALTER INDEX 垂鍙婪埻滇 ALTER TABLE 䫘庯䘵嚘䔇嘵嚟䔇婔婻彆劉

傖嬉誻橬婔婻 ALTER INDEX OWNER 埻䓉嘖滇䯄婘媘䘖庖(婥婔婻躥只)㔗婔婻䘵嚘婉脘橬婔婻启噽臘䔇匂婂婉劯䔇欔橬蔙㔗櫹埻臖臘䔇欔橬蔙儖躻媘櫹埻䘵嚘䔇欔橬蔙㔗

婉噕螩媞櫹係䂘臘䘵嚘䔇傂嘘鄘彖㔗

冋床

麉变劉婔婻䯄橬䔇䘵嚘

ALTER INDEX distributors RENAME TO suppliers;

檪婔婻䘵嚘䓂媘彄埥崡婔婻臘䷺閘

ALTER INDEX distributors SET TABLESPACE fasttablespace;

櫹埻䘵嚘䔇剹嘉啹昄(啺垔臖䘵嚘桹濘櫇毕垄)

ALTER INDEX distributors SET (fillfactor = 75);
REINDEX INDEX distributors;

噚垹攓

ALTER INDEX 滇 PostgreSQL 欷匘

埽蓕

CREATE INDEX, REINDEX
劯锔饡釕嬉誕
ALTER GROUP婪婔亓ALTER LANGUAGE