Thread: tablespace

tablespace

From
Eugene Yin
Date:
<div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida
Grande,sans-serif;font-size:13px"><div id="yui_3_16_0_1_1453003373099_4100">Compare the tablespace concept between
Oracleand Postgres.</div><div id="yui_3_16_0_1_1453003373099_4100"><br /></div><div
id="yui_3_16_0_1_1453003373099_4100">WhenI create a table, it is placed in a default tablespace such as "USERS", unless
Ispecify a user created tablespace, say, MyTableSpace.</div><div id="yui_3_16_0_1_1453003373099_4100"><br /></div><div
id="yui_3_16_0_1_1453003373099_4100">Forexample,</div><div id="yui_3_16_0_1_1453003373099_4100"><br /></div><div
id="yui_3_16_0_1_1453003373099_4100">createtable test_tab(</div><div id="yui_3_16_0_1_1453003373099_4100"><br
/></div><divid="yui_3_16_0_1_1453003373099_4100">name varchar2(100),</div><div dir="ltr"
id="yui_3_16_0_1_1453003373099_4100">photoBLOB,</div><div dir="ltr" id="yui_3_16_0_1_1453003373099_4100">text  
CLOB</div><divid="yui_3_16_0_1_1453003373099_4100">)</div><div dir="ltr"
id="yui_3_16_0_1_1453003373099_4100">tablespace"USERS"   --default</div><div dir="ltr"
id="yui_3_16_0_1_1453003373099_4100">lob("photo")  tablespace "MyTableSpace"   --user created</div><div class=""
dir="ltr"id="yui_3_16_0_1_1453003373099_4100">lob ("text")  tablespace "MyTableSpace"    --user created</div><div
class=""dir="ltr" id="yui_3_16_0_1_1453003373099_4100"><br /></div><div class="" dir="ltr"
id="yui_3_16_0_1_1453003373099_4100"><br/></div><div class="" dir="ltr" id="yui_3_16_0_1_1453003373099_4100">Now,
convertthe above table to the counterpart in Postgres.  Where will those columns be placed?</div><div class=""
dir="ltr"id="yui_3_16_0_1_1453003373099_4100"><br /></div><div class="" dir="ltr"
id="yui_3_16_0_1_1453003373099_4100">Adefault tablespace?  User create tablespace?  Or some proprietary logical
structurein Postgres?</div><div class="" dir="ltr" id="yui_3_16_0_1_1453003373099_4100"><br /></div><div class=""
dir="ltr"id="yui_3_16_0_1_1453003373099_4100"><br /></div><div class="" dir="ltr"
id="yui_3_16_0_1_1453003373099_4100"><br/></div><div class="" dir="ltr"
id="yui_3_16_0_1_1453003373099_4100">Thanks</div><divclass="" dir="ltr" id="yui_3_16_0_1_1453003373099_4100"><br
/></div><divclass="" dir="ltr" id="yui_3_16_0_1_1453003373099_4100">Eugene </div><div class="" dir="ltr"
id="yui_3_16_0_1_1453003373099_4218"><brclass="" id="yui_3_16_0_1_1453003373099_4220" /></div><div
id="yui_3_16_0_1_1453003373099_4100"> </div></div>