This is a utility which will run through a PostgreSQL based database and returns HTML, Dot, Dia and DocBook XML which describes the database (schema structure, etc.).
The PostgreSQL Autodocproject is a PostgreSQL Community project that is a part of the pgFoundry.
The pgFoundry page for the project is at http://pgfoundry.org/projects/autodoc, where you can find downloads, documentation, bug reports, mailing lists, and a whole lot more.