Re: v10beta pg_catalog diagrams

On 2017-06-13 1:22 PM, Bruce Momjian wrote:
> On Mon, Jun 12, 2017 at 04:07:35PM -0400, Peter Eisentraut wrote:
>> On 6/12/17 11:28, Neil Anderson wrote:
>>> I'm cross posting from general. I did some work to diagram the
>>> relationships in pg_catalog for v10. I would like to add it to the
>>> developer FAQ here
>>> https://wiki.postgresql.org/wiki/Developer_FAQ#Is_there_a_diagram_of_the_system_catalogs_available.3F
>>> but I thought I should check if people thought it appropriate and useful
>>> before I do?
>>>
>>> https://www.postgrescompare.com/2017/06/11/pg_catalog_constraints.html
>>
>> Go for it.
>
> Yeah, great. We have been talking about adding diagrams to our
> official docs but needed an updated toolchain, which I think we now
> have, so there is a lot of opportunity for growth here.
>

Wonderful. I've added it.

There were a few relationships that I couldn't capture. Like where in
pg_extension extconfig is an array of oids that refer to pg_class or
where pg_depends could refer to basically any other system catalog, but
it's mostly there and has all 62 tables from pg_catalog.

--
Neil Anderson
neil(at)postgrescompare(dot)com
http://www.postgrescompare.com