| From: | Erik Jones <erik(at)myemma(dot)com> |
|---|---|
| To: | Charles Mortell <cmortell(at)apt-cafm(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How determine a Views dependents |
| Date: | 2007-06-22 17:29:06 |
| Message-ID: | BD9B433F-00BE-4E33-A804-4B059DBA889A@myemma.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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®
erik(at)myemma(dot)com
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-06-22 17:30:35 | Re: SPI using perl |
| Previous Message | Tom Lane | 2007-06-22 17:28:16 | Re: Embedded C++ with ecpg? |