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