From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Sandra Arnold <ArnoldS@osti.gov>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Changing default tablespace for specific users -- Is it possible?
Date: Fri, 04 Feb 2011 13:26:02 -0600
Message-ID: <4D4BFE6A020000250003A3FF@gw.wicourts.gov> (raw)
In-Reply-To: <54E5385D47A89542BC678F5426799F3904EED3A6F8@OSTIEX01.osti.gov>
References: <54E5385D47A89542BC678F5426799F3904EED3A6F8@OSTIEX01.osti.gov>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, ArnoldS@osti.gov
Subject: Re: Changing default tablespace for specific users -- Is it possible?
In-Reply-To: <4D4BFE6A020000250003A3FF@gw.wicourts.gov>
References: <54E5385D47A89542BC678F5426799F3904EED3A6F8@OSTIEX01.osti.gov> <4D4BFE6A020000250003A3FF@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox