Postgres Pro
Downloads
Home   >   mailing lists

How do I find what views depend on a particular table? - Mailing list pgsql-general

From Justin Tocci
Subject How do I find what views depend on a particular table?
Date
Msg-id FCC16A7FBE5D074D9E53A8414424E2AC138D4B@TLCFWA1NT400
Whole thread Raw
Responses Re: How do I find what views depend on a particular table?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
I've found the pg_depend table, but it doesn't appear to include this info.
(Or am I missing it?)

I'm looking to get all view names that I need to drop to allow a particular
table to DROP RESTRICT.

Alternately, I would be happy with a way to get the names of objects that
are dropped when DROP CASCADE is used.


-------------------------------------------
justin tocci
Fort Wayne, IN

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Need feedback on new feature (\for)
Next
From: rifki
Date:
Subject: support for OO query