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 through it with
PGAdmin. In
an organized way, how can I find out what those dependents are?
If I need to use pg_depend, I could use some help in how to do that.
Thanks!
Have you looked at the output of \d <view name> in psql?
Erik Jones
Software Developer | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
