km <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
