Changing schema owner?

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.