Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aKqCA-0000Vt-FY for pgsql-sql@arkaria.postgresql.org; Sun, 17 Jan 2016 16:28:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aKqC9-00016S-4p for pgsql-sql@arkaria.postgresql.org; Sun, 17 Jan 2016 16:28:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aKqC7-00016J-65 for pgsql-sql@postgresql.org; Sun, 17 Jan 2016 16:28:47 +0000 Received: from nm39-vm3.bullet.mail.bf1.yahoo.com ([72.30.239.147]) by magus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aKqBz-00072n-Gq for pgsql-sql@postgresql.org; Sun, 17 Jan 2016 16:28:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s2048; t=1453048116; bh=qPgBJ6F324XvBznMtqUEMLmzon2XORhV+hDPaFEqgUQ=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=ntNueVX6zFMYIdWthGj1TNB0ZcdlUknt8aNrwujePzDbZdFIVV9KE5+on/WIjXdoYuo4KtR5gI0MJauu3rknwhMdvGKPwqYQkomkOOatdM0qxx6W9WkQGG1VGrHkV9ItOk5hm253yKOTSC/jYJqeodViNPa3zjelXxYbl8mok7/ZZCYoU3h5BNP3VV69Z75wzgqX4BCXtYD+L0UcCtopwuwHVnmx36FDQvO3dnREDvzQbwTPHUzttSUgqMHD5SjEugbIqlHo442ctUf2/YnOuzX3iMDC3HRPvmJoKZJh2JhxaXhcIAQ06Cia3Lc8PnsqfEQpDSHx7BLDQmcIdiv7BQ== Received: from [98.139.170.180] by nm39.bullet.mail.bf1.yahoo.com with NNFMP; 17 Jan 2016 16:28:36 -0000 Received: from [98.139.212.222] by tm23.bullet.mail.bf1.yahoo.com with NNFMP; 17 Jan 2016 16:28:36 -0000 Received: from [127.0.0.1] by omp1031.mail.bf1.yahoo.com with NNFMP; 17 Jan 2016 16:28:36 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 754108.30773.bm@omp1031.mail.bf1.yahoo.com X-YMail-OSG: dzINZ3oVM1kMsZGf6CxMRWlpHlpVDCIDReXa0BspiPan69UaTw_eS8X8cXJhIfo uZWVmS69F8oR3D5JkcQZ2AoLpegWWF5vSUpqTf7NCONkw5ttaY.oCtjK7OD5mcUKG0Zuj.yhieRo BtU5xmuQFTIlGr4IblZd.jtuw26LtLGX1NsC5o5lSE6uIpXuBHsddieVfW_wqrlTOg7X_ISieNF1 ArK4WXIoo114jCdjj5Tj58ZVbD6Sx2e6dIRYzX6BPnWcXu6j25p.FQGFL2I9ovgwoc5nCoHEP17l AyGQvwv7AexZWiE6AbozdVVTmW2laYJgspcuhfEQxh1dfiuzzEJWlYrjPDspLsWYaRbcr01Xt1cd 4W48H3p40pGN4FcxiTHz_NND0EC.Ma8fyzIRqZJHiY.RO8gup2jn7_e8N1ZbJGKRBgca1AigNS5S 1CTlMyfhqQxeyyP3hq6YMirbw..jFO62pdR6lpQ50wILfkn25t3af8oNGlll4PvVdLwW6yFgMMDq u7bMjSL3LoJ5sE.3VwerkqnQQE2I- Received: by 66.196.80.144; Sun, 17 Jan 2016 16:28:36 +0000 Date: Sun, 17 Jan 2016 16:28:28 +0000 (UTC) From: Eugene Yin Reply-To: Eugene Yin To: "pgsql-sql@postgresql.org" Message-ID: <817370552.6973098.1453048108502.JavaMail.yahoo@mail.yahoo.com> Subject: tablespace MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6973097_1733251259.1453048108498" References: <817370552.6973098.1453048108502.JavaMail.yahoo.ref@mail.yahoo.com> Content-Length: 3821 X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org ------=_Part_6973097_1733251259.1453048108498 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Compare the tablespace concept between Oracle and Postgres. When I create a table, it is placed in a default tablespace such as "USERS"= , unless I specify a user created tablespace, say, MyTableSpace. For example, create table test_tab( name varchar2(100),photo BLOB,text =C2=A0 CLOB)tablespace "USERS" =C2=A0 --= defaultlob ("photo") =C2=A0tablespace "MyTableSpace" =C2=A0 --user createdl= ob ("text") =C2=A0tablespace "MyTableSpace" =C2=A0 =C2=A0--user created Now, convert the above table to the counterpart in Postgres. =C2=A0Where wi= ll those columns be placed? A default tablespace? =C2=A0User create tablespace? =C2=A0Or some proprieta= ry logical structure in Postgres? Thanks Eugene=C2=A0 =C2=A0 ------=_Part_6973097_1733251259.1453048108498 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Comp= are the tablespace concept between Oracle and Postgres.

When I create a table, it is placed in a default tablespace such a= s "USERS", unless I specify a user created tablespace, say, MyTableSpace.

For example,

create = table test_tab(

=
name varchar2(100),
photo BLOB,
text   CLOB
)
tablespace "USERS"   --default
lob ("photo")  table= space "MyTableSpace"   --user created
lob ("text")  tablespace "MyTa= bleSpace"    --user created


Now, convert the above table to the = counterpart in Postgres.  Where will those columns be placed?

<= div id=3D"yui_3_16_0_1_1453003373099_4100" dir=3D"ltr" class=3D"">A default= tablespace?  User create tablespace?  Or some proprietary logica= l structure in Postgres?



Thanks

Eugene 

&n= bsp;
------=_Part_6973097_1733251259.1453048108498--