Re: Changing schema owner?
От
Francisco Reyes
Тема
Re: Changing schema owner?
Дата
Msg-id
20040306204924.I32516@zoraida.natserv.net
Ответ на
Re: Changing schema owner? (Tom Lane)
Список
Дерево обсуждения
Changing schema owner? Francisco Reyes <lists@natserv.com>
Re: Changing schema owner? Tom Lane <tgl@sss.pgh.pa.us>
Re: Changing schema owner? Francisco Reyes <lists@natserv.com>
On Tue, 10 Feb 2004, Tom Lane wrote: > Francisco Reyes 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.
В списке pgsql-general по дате отправления
