How to find object dependencies in PG 8.4
| От | venkatrao.b@tcs.com |
|---|---|
| Тема | How to find object dependencies in PG 8.4 |
| Дата | |
| Msg-id | OF676E361A.C5F1A0F7-ON652576FE.001D7CD1-652576FE.001E473F@tcs.com обсуждение исходный текст |
| Список | pgsql-novice |
Hi All,
I need to find object dependencies in postgres 8.4 database. Mainly i am concerned about how functions are dependent(one function calling other one) of one another. In oracle, we have options of _dpendency views( user_dependecy,all_dependency and dba_dependecy).
Is there any equivalent available in Postgres 8.4. I have seen pg_depend catalog, but I don't know, is this the one which i am looking for; also how to use this catalog (join with other catalogs ??).
Can anyone kindly help me in this regard.
Venkat
=====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
В списке pgsql-novice по дате отправления: