This is a utility which will run through PostgreSQL system tables and returns HTML, Dot, Dia and DocBook XML which describes the database.
apt-get install postgresql_autodoc
official site
