Re: pg_catalog tables don't have constraints?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_catalog tables don't have constraints?
Date: 2017-06-09 19:04:20
Message-ID: oherfi$2vv$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

kbrannen(at)pwhome(dot)com schrieb am 09.06.2017 um 20:57:
> Neil Anderson <neil(at)postgrescompare(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message armand pirvu 2017-06-09 20:31:20 Re: Vacuum and state_change
Previous Message kbrannen 2017-06-09 18:57:25 Re: pg_catalog tables don't have constraints?