find all views depend on a schema/table

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: find all views depend on a schema/table
Date: 2014-01-24 15:55:57
Message-ID: 52E28D0D.3080908@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

Is there a simple way to query all views depend on a schema or table?

E.g.,
view_schema| view_name | depends on schema_name | depends on t1
===========|===========|========================|================
v_schema |v1 | test | t1

"v_schema.v1" is defined as select .... from test.t1... where;

Thanks a lot!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2014-01-24 16:23:20 Re: find all views depend on a schema/table
Previous Message minsheng.bai 2014-01-24 02:06:21 consulting the question about the usage about SSH Tunnel function