Re: Best way to list a role’s owned objects?

Поиск
Список
Период
Сортировка
От Felipe Gasper
Тема Re: Best way to list a role’s owned objects?
Дата
Msg-id 53B2FB7B.8010007@felipegasper.com
обсуждение исходный текст
Ответ на Re: Best way to list a role’s owned objects?  (John R Pierce <pierce@hogranch.com>)
Ответы Re: Best way to list a roles owned objects?  (Jerry Sievers <gsievers19@comcast.net>)
Список pgsql-general
On 7/1/14 1:13 PM, John R Pierce wrote:
> On 7/1/2014 11:08 AM, Felipe Gasper wrote:
>>     What is the best way to list a role’s owned objects in any database?
>
> query pg_class in each database ?
>

Every database on the cluster, individually, then? Is there no way to
query all databases at once?

I mean, *something* under the hood must be doing this because DROP ROLE
bugs out if the role owns anything in any DB.

-F


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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Best way to list a role’s owned objects?
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: Best way to list a roles owned objects?