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.
