"Arnold, Sandra" <arno...@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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to