On Wed, 2004-08-18 at 08:57, Fabien COELHO wrote:
>
> > > > 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.
>
And using 8.0... I saw that but was looking for a 7.4 solution...
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL