Re: db andtable schemas

---  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