That's a great start, thanks! You should put a pointer to that page in the Pg wiki. I think the 1 thing that would really help it though is to show the actual connection/relations of the columns. For example, a line between pg_index and pg_class is not quite as informative as a line from pg_index.indexrelid to pg_class.oid (something the PNG file in the image that Thomas pointed out does). I suspect that's a limitation of the tool not your desire.
I think that might be possible, I may have turned off the labels on the edges.
Is this process automated, or does it require you to lay it out?
The layouts were all built in the DataGrip luckily!
In my perfect world, :) there would be a way to generate it automatically with Graphviz or something similar. Hmm, perhaps an idea to pursue when I can find some time. Kevin
I think SchemaSpy's new output looks really interesting and uses Graphviz. After doing the work to add the relationships I realised that SchemaSpy does not like the oid system columns that we use for keys so it wouldn't work. I will go ahead and replace them all with something else and see how it does but I haven't gotten back to it yet.
-- Neil Anderson neil@xxxxxxxxxxxxxxxxxxx http://www.postgrescompare.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
