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

CREATE TABLESPACE

劉䓄

CREATE TABLESPACE -- 垔幬婔婻桄臘䷺閘

臺濘

CREATE TABLESPACE tablespacename [ OWNER username ] LOCATION 'directory'

柟誄

CREATE TABLESPACE 濘喯婔婻桄䔇镖䆴评啘喙䔇臘䷺閘㔗臘䷺閘䔇劉庖媙釂婘臖昄扞康镖䆴婺䔇傂嘘䯄橬臘䷺閘婺嫇婔㔗

臘䷺閘噕螩轙亓䫘潙婘桺傽係䂘婺垔幬婔婻埇锬䔇嘉䘞認婻嘉䘞埇傖庻櫆傼臘昄扞康凹茇䔇昄扞桺傽(懫套臘启䘵嚘)㔗

婔婻䫘潙套悩橬劽锗䔇溄鍊儌埇傖檪 CREATE DATABASE, CREATE TABLE, CREATE INDEX, ADD CONSTRAINT 幋婔嚹锐䂍 tablespacename 認湙儌螷認底凹茇䔇昄扞桺傽庻嗘婘毺垔䔇臘䷺閘麯㔗

埗昄

tablespacename

襕录傺䔇臘䷺閘䔇劉庖㔗認婻劉庖婉脘傖 pg_ 嚔崘啹婺認底劉庖滇媺䘍䂍係䂘臘䷺閘嘪䫘䔇㔗

username

儖拖橬認婻臘䷺閘䔇䫘潙劉㔗套悩䩕䘖䚺䩕婺欓臯溴变傴䔇䫘潙劉㔗埻橬轙亓䫘潙埇傖录傺臘䷺閘嘖滇傡傸埇傖檪臘䷺閘䔇欔橬溄蕋庽麂轙亓䫘潙㔗

directory

䫘庯臘䷺閘䔇䕞嘘㔗䕞嘘媙釂滇䷺䔇幽婫䫌誊臯 PostgreSQL 係䂘䫘潙欔橬㔗䕞嘘媙釂䫘婔婻䂺凹虇冇弄滯㔗

濘懟

埻橬婘闼底櫇毕严埙誂毖䔇係䂘婪欉櫇毕臘䷺閘㔗

CREATE TABLESPACE 婉噕螩婘婔婻庋媇庖喙鄘欓臯㔗

冋床

婘 /data/dbs 录傺婔婻臘䷺閘 dbspace

CREATE TABLESPACE dbspace LOCATION '/data/dbs';

婘 /data/indexes 录傺婔婻臘䷺閘 indexspace 幽䫌䫘潙 genevieve 欔橬

CREATE TABLESPACE indexspace OWNER genevieve LOCATION '/data/indexes';

噚垹攓

CREATE TABLESPACE 滇 PostgreSQL 欷匘

埽蓕

CREATE DATABASE, CREATE TABLE, CREATE INDEX, DROP TABLESPACE, ALTER TABLESPACE
劯锔饡釕嬉誕
CREATE TABLE AS婪婔亓CREATE TRIGGER