Re: schema 8.1.5

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