SchemaSpy

I was introduced to a wonderful db tool.  SchemaSpy ... when configured and run, it generates a set of HTML pages.  Load the index.html in a browser. Provides a graphical view as well as lots of information about the db schema.

SchemaSpy is downloadable here http://schemaspy.sourceforge.net/
You run SchemaSpy from the command line like so:

java -jar schemaSpy.jar -t dbType -db dbName [-s schema] -u user [-p password] -o outputDir -dp pathToDrivers

example:
$ java -jar schemaSpy_5.0.0.jar -t pgsql -db amp_test_20130114 -u meridian -p meridian -host localhost -o ./amp -dp /home/steveh/.m2/repository/postgresql/postgresql/9.0-801.jdbc4/postgresql-9.0-801.jdbc4.jar -s sdp