Re: List of objects owned by a schema/owner

2018-08-03 Thread Tiffany Thang
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 > > owner?

Re: List of objects owned by a schema/owner

2018-08-03 Thread Tom Lane
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 > owner? I find fragments of information here and there that query on > pg_tables, pg_views, etc. Well, you could attack i