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

From: Felipe Gasper <felipe(at)felipegasper(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Best way to list a role’s owned objects?
Date: 2014-07-01 18:18:35
Message-ID: 53B2FB7B.8010007@felipegasper.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Sievers 2014-07-01 18:31:54 Re: Best way to list a roles owned objects?
Previous Message John R Pierce 2014-07-01 18:13:16 Re: Best way to list a role’s owned objects?