Postgres Pro
Downloads
Home   >   mailing lists

Re: Change owner for all tables in a database in one batch - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Change owner for all tables in a database in one batch
Date
Msg-id 20130306131948.GS9507@alvh.no-ip.org
Whole thread Raw
In response to Change owner for all tables in a database in one batch  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Alexander Farber
Date:
Subject: Change owner for all tables in a database in one batch
Next
From: Chris Angelico
Date:
Subject: Re: Finding matching words in a word game