Greg Stark <st...@enterprisedb.com> writes: > On Fri, May 29, 2009 at 5:10 PM, Emi Lu <em...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general