Re: dropping role w/dependent objects

Ed L. wrote:
> On Wednesday April 4 2007 4:35 pm, Alvaro Herrera wrote:
> >
> > Note that you can give the objects owned by that role to
> > someone else with REASSIGN OWNED, and drop the objects with
> > DROP OWNED (note that they act differently regarding grants;
> > see the docs)
>
> Yes, but how do identify what they are so that I know if I want
> to DROP OWNED them?

There's no way AFAICT, short of peeking the catalogs (or
information_schema). Try pg_shdepend.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support