Postgres Pro
Downloads
Home   >   mailing lists

Re: SCHEMA's - Mailing list pgsql-sql

From Tom Lane
Subject Re: SCHEMA's
Date
Msg-id 19652.1046744740@sss.pgh.pa.us
Whole thread Raw
In response to SCHEMA's  ("Hepworth, Mike" <mike.hepworth@pbs.proquest.com>)
List pgsql-sql
Tree view 
"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

pgsql-sql by date:

Previous
From: "Hepworth, Mike"
Date:
Subject: SCHEMA's
Next
From: Tom Lane
Date:
Subject: Re: Query Against a dblink View Takes Too Long to Return