Re: How can I look at a recursive table dependency tree? - Mailing list pgsql-general

Greg Stark <stark@enterprisedb.com> writes:
> On Fri, May 29, 2009 at 5:10 PM, Emi Lu <emilu@encs.concordia.ca> wrote:
>> Is it possible to find all view names depend on one table?

> With 8.4 you can use a query like this (change 'messages' to your table name)

In earlier versions the usual trick is

    BEGIN;
    DROP VIEW whatever RESTRICT;
    ... read the error message ...
    ROLLBACK;

            regards, tom lane