From: | David Kerr <dmk(at)mr-paradox(dot)net> |
---|---|
To: | Florian Pflug <fgp(at)phlo(dot)org> |
Cc: | carl clemens <carlclemens1(at)yahoo(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: default_tablespace |
Date: | 2011-02-17 20:01:56 |
Message-ID: | 20110217200156.GB24065@mr-paradox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Feb 17, 2011 at 08:55:55PM +0100, Florian Pflug wrote:
- 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
oh, you're right. my mistake.
and it looks like it's stored in useconfig in pg_user.
select * from pg_user where usename = 'david.kerr';
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig
------------+----------+-------------+----------+-----------+----------+----------+---------------------------
david.kerr | 16482 | f | t | t | ******** | | {default_tablespace=test}
Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2011-02-17 20:06:34 | Re: Add support for logging the current role |
Previous Message | Oleg Bartunov | 2011-02-17 19:57:35 | Re: tsearch Parser Hacking |