"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