Re: SCHEMA's

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hepworth, Mike" <mike(dot)hepworth(at)pbs(dot)proquest(dot)com>
Cc: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SCHEMA's
Date: 2003-03-04 02:25:40
Message-ID: 19652.1046744740@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Hepworth, Mike" <mike(dot)hepworth(at)pbs(dot)proquest(dot)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

In response to

  • SCHEMA's at 2003-03-04 01:30:40 from Hepworth, Mike

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-03-04 02:43:27 Re: Query Against a dblink View Takes Too Long to Return
Previous Message Hepworth, Mike 2003-03-04 01:30:40 SCHEMA's