Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: schema 8.1.5
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: km(at)mrna(dot)tn(dot)nic(dot)in
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: schema 8.1.5
- Date: Thu, 26 Oct 2006 17:27:42 -0400
km <km(at)mrna(dot)tn(dot)nic(dot)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
- References:
- schema 8.1.5
- From: km
- schema 8.1.5
- Prev by Date: Re: Effect of large text field data on queries
- Next by Date: Re: Effect of large text field data on queries
- Previous by thread: Re: schema 8.1.5
- Next by thread: Possible problem with PQescapeStringConn and standard_conforming_strings
- Indexes: