Excerpts from Florian Pflug's message of jue feb 17 16:55:55 -0300 2011:

> 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...

It's in pg_db_role_settings.

-- 
Álvaro Herrera <alvhe...@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to