Re: default_tablespace

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 <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support