Re: List of objects owned by a schema/owner

Thanks Tom for giving me the lead. I’ll take a look. On Fri, Aug 3, 2018 at 10:52 AM Tom Lane wrote: > Tiffany Thang writes: > > Does anyone have a query that will list all the objects (composite types, > > sequences, tables, triggers, functions, indices, etc) owned by a schema > or > >

List of objects owned by a schema/owner

Hi, Does anyone have a query that will list all the objects (composite types, sequences, tables, triggers, functions, indices, etc) owned by a schema or owner? I find fragments of information here and there that query on pg_tables, pg_views, etc. Thanks.