X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 10BCE475D64
	for <pgsql-sql@postgresql.org>; Mon,  3 Mar 2003 21:25:44 -0500 (EST)
Received: from postgresql.org ([64.49.215.8])
	by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with
	SMTP id 91571-07 for <pgsql-sql@postgresql.org>;
	Mon,  3 Mar 2003 21:25:42 -0500 (EST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id 3937D475C60
	for <pgsql-sql@postgresql.org>; Mon,  3 Mar 2003 21:25:42 -0500 (EST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.8/8.12.8) with ESMTP id h242Pex6019653;
	Mon, 3 Mar 2003 21:25:40 -0500 (EST)
To: "Hepworth, Mike" <mike.hepworth@pbs.proquest.com>
Cc: "'pgsql-sql@postgresql.org'" <pgsql-sql@postgresql.org>
Subject: Re: SCHEMA's 
In-reply-to: 
 <BA4D671159071C49929FCB5CCCDB9D070144C4@sl2exc1.sl2server.power.bellhow.com>
References: 
 <BA4D671159071C49929FCB5CCCDB9D070144C4@sl2exc1.sl2server.power.bellhow.com>
Comments: In-reply-to "Hepworth, Mike" <mike.hepworth@pbs.proquest.com>
	message dated "Mon, 03 Mar 2003 18:30:40 -0700"
Date: Mon, 03 Mar 2003 21:25:40 -0500
Message-ID: <19652.1046744740@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200303/106
X-Sequence-Number: 12146

"Hepworth, Mike" <mike.hepworth@pbs.proquest.com> writes:
> I want to be able make a user have a default schema other than public.

If the schema name is the same as the user name then this happens
automatically.

Otherwise, you want to set a search_path value for the user --- see
ALTER USER and read up on the search_path runtime parameter.

			regards, tom lane