[GENERAL] How determine a Views dependents

2007-06-22 Thread Charles Mortell
Fellow Postgressors, 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,

Re: [GENERAL] How determine a Views dependents

2007-06-22 Thread Tom Lane
"Charles Mortell" <[EMAIL PROTECTED]> 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 PG

Re: [GENERAL] How determine a Views dependents

2007-06-22 Thread Erik Jones
On Jun 22, 2007, at 10:50 AM, Charles Mortell wrote: Fellow Postgressors, 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