"Arnold, Sandra" <ArnoldS@xxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin