SchemaSpy is an awesome tool for database schema reporting.

aogail@aleath ~ $ java -cp /usr/share/jdbc2-postgresql-6/lib/pg74.215.jdbc2.jar -jar schemaSpy_2.1.0.jar \
-t pgsql -o test -host localhost:1337 -db jansenbe -u jansenbe -p password -s assign3
Using database properties:
    [schemaSpy_2.1.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Connected to PostgreSQL - 8.0.3

Gathering schema details...........................(14sec)
Writing/graphing summary...........(7sec)
Writing/graphing results...........................(49sec)
Wrote relationship details of 27 tables/views to directory 'test' in 71 seconds.
Start with test/index.html

HOWTO for converting from MSSQL to Postgres.