tablespace

Поиск
Список
Период
Сортировка
От Eugene Yin
Тема tablespace
Дата
Msg-id 817370552.6973098.1453048108502.JavaMail.yahoo@mail.yahoo.com
обсуждение исходный текст
Список 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"   --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 по дате отправления: