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