Postgres Pro
Downloads
Home   >   mailing lists

Changing default tablespace for specific users -- Is it possible? - Mailing list pgsql-admin

From Arnold, Sandra
Subject Changing default tablespace for specific users -- Is it possible?
Date
Msg-id 54E5385D47A89542BC678F5426799F3904EED3A6F8@OSTIEX01.osti.gov
Whole thread Raw
Responses Re: Changing default tablespace for specific users -- Is it possible?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Tree view
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
 

pgsql-admin by date:

Previous
From: Joby Joba
Date:
Subject: pg_standby and compressed archive
Next
From: "Kevin Grittner"
Date:
Subject: Re: Changing default tablespace for specific users -- Is it possible?