Change owner for all tables in a database in one batch

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Change owner for all tables in a database in one batch
Дата
Msg-id CAADeyWhbnMGG6Gp3cywXCx9DxOY7TJPfAUA-0iim-ocB4VL7Kg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Change owner for all tables in a database in one batch
Список pgsql-general
Hello,

by accident I have wrong owner for all tables in my 8.4.13 database:

bukvy=> select * from pg_tables where tableowner = 'skat';
 schemaname |             tablename              | tableowner |
tablespace | hasindexes | hasrules | hastriggers
------------+------------------------------------+------------+------------+------------+----------+-------------
 public     | drupal_actions                     | skat       |
    | t          | f        | f
 public     | drupal_batch                       | skat       |
    | t          | f        | f
 public     | drupal_authmap                     | skat       |
    | t          | f        | f
....
 public     | drupal_watchdog                    | skat       |
    | t          | f        | f
(83 rows)

But they actually should have the user "bukvy" as the owner.

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?

Thank you
Alex


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

Предыдущее
От: Glyn Astill
Дата:
Сообщение: Re: Why does slony use a cursor? Anyone know?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Change owner for all tables in a database in one batch