"Hepworth, Mike" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to