> > > Database owner should have implicit control over public schema
> >
> > There has been some discussion of causing the public schema to be owned
> > by the DB owner, but this has not happened yet, partly because we are
> > not sure of all the consequences.
>
> was just looking at this this morning. is there anyway to change
> ownership of a schema? i couldn't find one and thought i'd ask before
> whacking on the system tables.
"ALTER SCHEMA foo OWNER TO bla" if you're a super user.
--
Fabien Coelho - coelho@cri.ensmp.fr