List Foreign Key Relationships

From: Tim Jones <tij(at)ucs(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: List Foreign Key Relationships
Date: 2002-10-02 15:54:31
Message-ID: 3D9B16B7.2010408@ucs.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

I am try to query the dictionary to get a list of the foreign key
relationships in the dictionary.
Say in the form Primary Key Table, Primary Column(s), Foreign Key Table,
Foreing Key Column(s)
Any ideas. I suppose I could try and unpack the bytea in pg_trigger. Any
other ideas?

Tim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michelle Konzack 2002-10-02 16:01:48 Import textfile as table
Previous Message Weaver, Walt 2002-10-02 15:35:57 Re: PL/SQL Developer and TOAD