From: | Florian Pflug <fgp(at)phlo(dot)org> |
---|---|
To: | David Kerr <dmk(at)mr-paradox(dot)net> |
Cc: | carl clemens <carlclemens1(at)yahoo(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: default_tablespace |
Date: | 2011-02-17 19:55:55 |
Message-ID: | 5A225F4D-2889-45AC-8E4C-A00535FFCF29@phlo.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Feb17, 2011, at 18:32 , David Kerr wrote:
> On Wed, Feb 16, 2011 at 03:59:13PM -0800, carl clemens wrote:
> - After reviewing docs and searching web
> - cannot find out how to determine the default tablespace
> - of a user?
>
> It doesn't appear to me that default tablespaces are assigned to a user, they're
> assigned to a database.
>
> A user can set the variable default_tablespace in their session to over-ride the
> database default, but that wouldn't be stored anywhere in the database (it's a client
> variable).
You can, however, do ALTER USER <user> SET default_tablespace=<whatever>, which will
cause default_tablespace to be set automatically upon login for that user.
I don't know of the top of my head how we store that in the system catalogs, though.
You'll have to check the documentation to find that out...
best regards,
Florian Pflug
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2011-02-17 19:57:35 | Re: tsearch Parser Hacking |
Previous Message | Daniel Loureiro | 2011-02-17 19:51:25 | Coding style guide |