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

ALTER SCHEMA

劉䓄

ALTER SCHEMA -- 媞櫹婔婻昇嚟䔇垔幬

臺濘

ALTER SCHEMA name RENAME TO newname
ALTER SCHEMA name OWNER TO newowner

柟誄

ALTER SCHEMA 媞櫹婔婻昇嚟䔇垔幬㔗

襕嘪䫘 ALTER SCHEMA 嘹媙釂拖橬臖昇嚟㔗襕䂍婔婻昇嚟麉变劉嘹媙釂婘臖昄扞康婪橬 CREATE 溄鍊㔗襕媞櫹欔橬蔙嘹誻媙釂滇桄䔇欔橬蓐謾䔇䕘毖潡閘毖潊叻幽婫臖潊叻媙釂婘溴昄扞康婪橬 CREATE 溄鍊㔗轙亓䫘潙躻媘拖橬噘鄘溄鍊㔗

埗昄

name

䯄橬昇嚟䔇劉庖

newname

昇嚟䔇桄劉庖桄劉庖婉脘傖 pg_ 嚔崘啹婺認底劉庖滇媺䘍䂍係䂘昇嚟䔇㔗

newowner

昇嚟䔇桄欔橬蔙

噚垹攓

SQL 湺庖麯澇橬 ALTER SCHEMA 臺埖㔗

埽蓕

CREATE SCHEMA, DROP SCHEMA

劯锔饡釕嬉誕
ALTER ROLE婪婔亓ALTER SEQUENCE