Hi there
I am creating a code generator to build our project from our postgress data base
But, what I cant seem to find is the sql to do the following
- 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
Many thanks
Jamie