Greg Stark <stark@xxxxxxxxxxxxxxxx> writes: > On Fri, May 29, 2009 at 5:10 PM, Emi Lu <emilu@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
