find all views depend on a schema/table - Mailing list pgsql-sql

From Emi Lu
Subject find all views depend on a schema/table
Date
Msg-id 52E28D0D.3080908@encs.concordia.ca
Whole thread Raw
Responses Re: find all views depend on a schema/table  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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!



pgsql-sql by date:

Previous
From: minsheng.bai
Date:
Subject: consulting the question about the usage about SSH Tunnel function
Next
From: Tom Lane
Date:
Subject: Re: find all views depend on a schema/table