Blog post: https://ejrh.wordpress.com/2012/08/29/schema-diagrams-for-postgresql/
Installation and usage:
apt-get install libpq-dev python-dev
apt-get install python-psycopg2
pgschemagraph.py -h HOST -d DATBASE -u USER -p PASSWORD [-s SCHEMAS] > schema.graphml