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

ALTER TABLESPACE

劉䓄

ALTER TABLESPACE -- 媞櫹婔婻臘䷺閘䔇垔幬

臺濘

ALTER TABLESPACE name RENAME TO newname
ALTER TABLESPACE name OWNER TO newowner

柟誄

ALTER TABLESPACE 櫹埻婔婻臘䷺閘䔇垔幬㔗

襕嘪䫘 ALTER TABLESPACE 嘹媙釂拖橬臖臖臘䷺閘㔗襕媞櫹欔橬蔙嘹誻媙釂滇桄䔇欔橬蓐謾䔇䕘毖潡閘毖潊叻㔗婉誺轙亓䫘潙躻媘诙冖認底溄鍊㔗

埗昄

name

婔婻䯄橬䔇臘䷺閘

newname

臘䷺閘䔇桄劉庖㔗桄劉庖婉脘傖 pg_ 嚔崘啹婺認湙䔇劉庖媺䘍䂍係䂘臘䷺閘䫘庖㔗

newowner

臘䷺閘䔇桄欔橬蔙

冋床

檪臘䷺閘 index_space 麉变劉婺 fast_raid

ALTER TABLESPACE index_space RENAME TO fast_raid;

臖埻臘䷺閘 index_space 䔇欔橬蔙

ALTER TABLESPACE index_space OWNER TO mary;

噚垹攓

SQL 湺庖麯澇橬 ALTER TABLESPACE 臺埖㔗

埽蓕

CREATE TABLESPACE, DROP TABLESPACE

劯锔饡釕嬉誕
ALTER TABLE婪婔亓ALTER TRIGGER