Обсуждение: Changing default tablespace for specific users -- Is it possible?

Поиск
Список
Период
Сортировка

Changing default tablespace for specific users -- Is it possible?

От
"Arnold, Sandra"
Дата:
Coming from the Oracle world we were able to have a different default tablespace for each user or for a group of users.  Can you set the default tablespace to be different for a group users/schemas in PostgreSQL?  Or, do you have to set the default tablespace at the database level?  If you can set it at a schema/user level, can you direct me some documentation on how to do that?
 
Thanks,
 
Sandra Arnold
Senior Database Administrator
Contractor to DOE/OSTI
NCI, Inc.
Oak Ridge, TN
(865) 576-0054 (work)
(865) 567-7553 (cell)
arnolds@osti.gov
 

Re: Changing default tablespace for specific users -- Is it possible?

От
"Kevin Grittner"
Дата:
"Arnold, Sandra" <ArnoldS@osti.gov> wrote:

> Coming from the Oracle world we were able to have a different
> default tablespace for each user or for a group of users.  Can you
> set the default tablespace to be different for a group
> users/schemas in PostgreSQL?

ALTER ROLE xxx SET default_tablespace = yyy;

http://www.postgresql.org/docs/current/interactive/sql-alterrole.html

-Kevin