--- Original Message From: Jamie Lawrence Jenner ---
> Retrieve a list of tables from a given database
> How to retrieve a list of table properties from a table
> how retireve what constraints a table has
> foreign ekeys
> primary keys
> I would be really greatful if someone could point me in the direction
Jamie, the type of metadata you're looking for is detailed in the
Information Schema:
http://www.postgresql.org/docs/8.2/static/infoschema-schema.html
and the PostgreSQL system catalogs:
http://www.postgresql.org/docs/8.2/static/catalogs-overview.html
You can use ordinary SQL queries to pull the inforamation you require from
these sources.
Regards,
George
