Postgres Pro
Downloads
Home   >   mailing lists

List of objects owned by a schema/owner - Mailing list pgsql-general

From Tiffany Thang
Subject List of objects owned by a schema/owner
Date
Msg-id CAB_W-NOH2U3qb9YS0DemzsaN+FXdsOsDOzXgfoHnMrWp7HBTxw@mail.gmail.com
Whole thread Raw
Responses Re: List of objects owned by a schema/owner
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Dmitry Igrishin
Date:
Subject: SQL Programming Assistant for PostgreSQL
Next
From: pinker
Date:
Subject: Re: List user who have access to schema