Re: Change owner for all tables in a database in one batch

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Change owner for all tables in a database in one batch
Дата
Msg-id 20130306131948.GS9507@alvh.no-ip.org
обсуждение исходный текст
Ответ на Change owner for all tables in a database in one batch  (Alexander Farber <alexander.farber@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Alexander Farber escribió:

> Is there maybe a one-liner for changing the ownership in 1 batch
> or should I execute "alter table .... set owner to bukvy" one by one?

The command REASSIGN OWNED changes ownership of all objects owned by a
certain role.  There's no way to restrict it to just tables, though.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-general по дате отправления:

Предыдущее
От: Alexander Farber
Дата:
Сообщение: Change owner for all tables in a database in one batch
Следующее
От: Chris Angelico
Дата:
Сообщение: Re: Finding matching words in a word game