Re: [GENERAL] pg_catalog tables don't have constraints?

> 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@postgrescompare.com
http://www.postgrescompare.com