Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-admin by date:

Previous
From: "Arnold, Sandra"
Date:
Subject: Changing default tablespace for specific users -- Is it possible?
Next
From: Vibhor Kumar
Date:
Subject: Re: pg_standby and compressed archive