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 по дате отправления: