"Charles Mortell" <cmortell@apt-cafm.com> writes:
> I took over an existing PG 8.0 database running on Windows XP. I need to
> update a view so I know I need to drop the existing view and all the objects
> that depend on it.
> The DB is large enough that I can't just look through it with PGAdmin. In
> an organized way, how can I find out what those dependents are?
The traditional way is
drop view victim restrict;
... read the error message ...
regards, tom lane