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