| From: | Eugene Yin <eugeneymail(at)ymail(dot)com> |
|---|---|
| To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | tablespace |
| Date: | 2016-01-17 16:28:28 |
| Message-ID: | 817370552.6973098.1453048108502.JavaMail.yahoo@mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 CLOB)tablespace "USERS" --defaultlob ("photo") tablespace "MyTableSpace" --user createdlob ("text") tablespace "MyTableSpace" --user created
Now, convert the above table to the counterpart in Postgres. Where will those columns be placed?
A default tablespace? User create tablespace? Or some proprietary logical structure in Postgres?
Thanks
Eugene
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eugene Yin | 2016-01-17 16:56:33 | Re: BYTEA vs BLOB |
| Previous Message | Andreas Joseph Krogh | 2016-01-17 15:01:03 | Re: BYTEA vs BLOB |