Thread: Changing schema owner?

Is there a way to change a schema owner other than dump/restore?
How about changing the nspowner in pg_namespace? Will that do the trick
without any negative consecuences?

Francisco Reyes <lists@natserv.com> writes:
> Is there a way to change a schema owner other than dump/restore?
> How about changing the nspowner in pg_namespace? Will that do the trick
> without any negative consecuences?

I think that will work, but experiment in a spare database ...

            regards, tom lane

On Tue, 10 Feb 2004, Tom Lane wrote:

> Francisco Reyes <lists@natserv.com> writes:
> > Is there a way to change a schema owner other than dump/restore?
> > How about changing the nspowner in pg_namespace? Will that do the trick
> > without any negative consecuences?
>
> I think that will work, but experiment in a spare database ...
>             regards, tom lane

I don't think I ever replied to this.
It worked. Changing nspowner in pg_namespace changed the owner of the
schema.