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


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to