"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