Andre Majorel <aym-2lqsgp <at> teaser.fr> writes:
>
> Suppose you want to write a program that connects to a
> PostgreSQL database and lists its tables and views, the type of
> their columns and their relationships (REFERENCES) for automatic
> joins.
I personally would try to hit the "informat_schema", which is a bunch of views
on system activity that follows a standard. I am not sure if what you want is in
there, like locks or other stuff, but for table names etc it works well.