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

From Emi Lu
Subject Re: find all views depend on a schema/table
Date
Msg-id 52E29D0B.4000201@encs.concordia.ca
Whole thread Raw
In response to Re: find all views depend on a schema/table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
>> Is there a simple way to query all views depend on a schema or table?
> Well, you could build something that examines pg_depend, or you could
> try this:

Thank you. I will try to find mapped results for pg_depend.

> begin;
> drop table some_table restrict;
> ... note what it complains about ...
> rollback;

No... to find all views(not in schema1) depend on any schema1.objects.










pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: consulting the question about the usage about SSH Tunnel function
Next
From: bobspero
Date:
Subject: Detecting when field value changes in Foreign Table?