km <km@xxxxxxxxxxxxxx> writes: > how do i set a user account to default to a predefined schema ? If you make the choice user name = schema name, this happens for free. See http://www.postgresql.org/docs/8.1/static/ddl-schemas.html The bit about common usage patterns might help in particular. > i have tried : > SET search_path TO myschema; > but thats temprary setting i suppose. Doesn't have to be. See postgresql.conf and ALTER USER. regards, tom lane
