Search Postgresql Archives

Re: Dependency tracking tool

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Philippe Lang" <philippe.lang@xxxxxxxxxxxxxx> writes:
> In order to have a "global map" of the dependencies of the functions,
> views, tables in a PG database, I'd like to have some sort of
> "dependency tracking tool", that would show for each object:

> - which other objects depend on this object
> - on which other objects this object depends

You can find the raw data for that in pg_depend; at least for the sorts
of dependencies that PG cares about, which might not be exactly what you
are looking for.  In particular we do not try to track what objects the
code inside a function might refer to.

> Is it correct to say that this "hierarchy" does not exist inside
> Postgresql, and that it is necessary to parse the INFORMATION_SCHEMA.*
> tables to get this information?

The information_schema views do not expose that information at all.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux