Hacker News Reader

To generate table diagrams that you can navigate (in HTML), SchemaSpy (http://schemaspy.sourceforge.net/) is really good.

http://www.pgadmin.org/ ?? but I am also new to postgresql. There are also some commercial tools available.

how?

IntelliJ