From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hepworth, Mike <mike.hepworth@pbs.proquest.com>
Cc: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: Re: SCHEMA's
Date: Mon, 03 Mar 2003 21:25:40 -0500
Message-ID: <19652.1046744740@sss.pgh.pa.us> (raw)
In-Reply-To: <BA4D671159071C49929FCB5CCCDB9D070144C4@sl2exc1.sl2server.power.bellhow.com>
References: <BA4D671159071C49929FCB5CCCDB9D070144C4@sl2exc1.sl2server.power.bellhow.com>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, mike.hepworth@pbs.proquest.com
Subject: Re: SCHEMA's
In-Reply-To: <19652.1046744740@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox