I've been poking around https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to see if there is anything that can read PG metadata in and display it graphically in a gui. You know, the kind of picture that is 1 block per table with 1->many arrows connecting up the primary/foreign keys of different tables. SQL Power Architect looked promising, but fails to do the linkage for some PK-FK relationships (buggy?) .