On Sun, Feb 05, 2006 at 07:18:33PM -0700, Tony Wasson wrote: > > I am maintaining an application that has over 400 procedures and functions > > written in plsql, and around 100 tables. > > I want to generate a function dependency chart to depict the following: > > > > 1. Inter function/procedure dependencies > > 2. function-tables dependencies > > 3. function-sequences depencies ... > I too would be interested in a standardized tool to do this. I had a > similar situation and I ended up writing a perl script to parse my SQL > and make a graphviz dot file. I then used graphviz to make a function > dependency chart. I can't promise it would catch every single case, > but I can provide you with the code if you wish to give it a whirl.
Tony, what do you think about sending a copy of this code to the pg_autodoc author ? I'm sure they'd be interested to have a look at this. http://www.rbt.ca/autodoc/index.html I have CC'ed this to the author. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
