Re: Changing schema owner? - Mailing list pgsql-general

From Tom Lane
Subject Re: Changing schema owner?
Date
Msg-id 14578.1076472128@sss.pgh.pa.us
Whole thread Raw
In response to Changing schema owner?  (Francisco Reyes <lists@natserv.com>)
Responses Re: Changing schema owner?
List pgsql-general
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

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: I want to use postresql for this app, but...
Next
From: "muteki muteki"
Date:
Subject: pg_class and relfilenode