tablespace
От
Eugene Yin
Тема
tablespace
Дата
Msg-id
817370552.6973098.1453048108502.JavaMail.yahoo@mail.yahoo.com
Список
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" --default
lob ("photo") tablespace "MyTableSpace" --user created
lob ("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
В списке pgsql-sql по дате отправления