From: | Neil Anderson <neil(at)postgrescompare(dot)com> |
---|---|
To: | kbrannen(at)pwhome(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_catalog tables don't have constraints? |
Date: | 2017-06-14 14:08:01 |
Message-ID: | 1e0dcf0e-7539-2eee-b4c6-95274637b81a@postgrescompare.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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(at)postgrescompare(dot)com
http://www.postgrescompare.com
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2017-06-14 16:00:09 | Re: pg_upgrade --link on Windows |
Previous Message | Klaus P. Pieper | 2017-06-14 07:59:04 | Re: pg_upgrade --link on Windows |