Re: Best way to list a role’s owned objects? - Mailing list pgsql-general

From Felipe Gasper
Subject Re: Best way to list a role’s owned objects?
Date
Msg-id 53B2FB7B.8010007@felipegasper.com
Whole thread Raw
In response to Re: Best way to list a role’s owned objects?  (John R Pierce <pierce@hogranch.com>)
Responses Re: Best way to list a roles owned objects?  (Jerry Sievers <gsievers19@comcast.net>)
List 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 by date:

Previous
From: John R Pierce
Date:
Subject: Re: Best way to list a role’s owned objects?
Next
From: Jerry Sievers
Date:
Subject: Re: Best way to list a roles owned objects?