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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
