List of objects owned by a schema/owner

From: Tiffany Thang <tiffanythang(at)gmail(dot)com>
To: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: List of objects owned by a schema/owner
Date: 2018-08-03 12:33:48
Message-ID: CAB_W-NOH2U3qb9YS0DemzsaN+FXdsOsDOzXgfoHnMrWp7HBTxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pinker 2018-08-03 14:26:25 Re: List user who have access to schema
Previous Message Dmitry Igrishin 2018-08-03 12:33:05 SQL Programming Assistant for PostgreSQL