km <km@mrna.tn.nic.in> 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