Re: Changing default tablespace for specific users -- Is it possible?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Sandra Arnold" <ArnoldS(at)osti(dot)gov>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Changing default tablespace for specific users -- Is it possible?
Date: 2011-02-04 19:26:02
Message-ID: 4D4BFE6A020000250003A3FF@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Arnold, Sandra" <ArnoldS(at)osti(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vibhor Kumar 2011-02-06 12:04:34 Re: pg_standby and compressed archive
Previous Message Arnold, Sandra 2011-02-04 19:00:38 Changing default tablespace for specific users -- Is it possible?