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
n...@postgrescompare.com
http://www.postgrescompare.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
