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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to