On Tue, 10 Feb 2004, Tom Lane wrote: > Francisco Reyes <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
