Integrity Relationships - Mailing list pgsql-general

From rob
Subject Integrity Relationships
Date
Msg-id 000801c05743$1e291c90$4100fd0a@cabrion.org
Whole thread Raw
List pgsql-general
Given a table name, is there a way to query one or more system tables to
determine what other tables it references via foreign keys?  The opposite
would work just as well (i.e. what other tables reference the given table).
I've looked at pg_triggers and there seems to be an attribute (trigger
arguments?)  that has the table names, but I don't know how to parse the
data correctly.

TIA,

--rob


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Warning: Don't delete those /tmp/.PGSQL.* files
Next
From: GH
Date:
Subject: Re: Warning: Don't delete those /tmp/.PGSQL.* files