Re: [GENERAL] pg_catalog tables don't have constraints? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: [GENERAL] pg_catalog tables don't have constraints?
Date
Msg-id oherfi$2vv$1@blaine.gmane.org
Whole thread Raw
In response to Re: [GENERAL] pg_catalog tables don't have constraints?  ("" <kbrannen@pwhome.com>)
List pgsql-general
kbrannen@pwhome.com schrieb am 09.06.2017 um 20:57:
> Neil Anderson <neil@postgrescompare.com> wrote:
>
>> I've been exploring the pg_catalog tables and pointed a couple of tools at
>> it to extract an ER diagram for a blog post. At first I thought it was a bug
>> in the drawing tool but it appears that the relationships between the
>> pg_catalog tables are implicit rather than enforced by the database, is that correct?
>
> Every time I have to dive into the pg_* tables, I really want such a diagram because
> the relationships aren't obvious to me, so I've been looking for a diagram like that
> and haven't found one.

https://wiki.postgresql.org/wiki/Developer_FAQ#Is_there_a_diagram_of_the_system_catalogs_available.3F



pgsql-general by date:

Previous
From: ""
Date:
Subject: Re: [GENERAL] pg_catalog tables don't have constraints?
Next
From: armand pirvu
Date:
Subject: Re: [GENERAL] Vacuum and state_change