How do I find what views depend on a particular table?

From: Justin Tocci <jtocci(at)tlcusa(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: How do I find what views depend on a particular table?
Date: 2003-08-25 03:01:16
Message-ID: FCC16A7FBE5D074D9E53A8414424E2AC138D4B@TLCFWA1NT400
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-08-25 08:48:52 Re: Need feedback on new feature (\for)
Previous Message rifki 2003-08-25 01:43:26 support for OO query