How do I SELECT primary/foreign keys?

From: ffrt <ffrt(at)ace(dot)ulyssis(dot)org>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: How do I SELECT primary/foreign keys?
Date: 2001-06-07 11:14:17
Message-ID: Pine.LNX.4.33.0106071309540.22426-100000@ace
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

for an algo I need to select the primary key and foreign keys from all the
colums in a given table. Is there any SELECT that can do this for me? I'm
currently looking into the postgresql standard tables, but I still didn't
find my way out.

Any help GREATLY appreciated.
Wim

--
ffrt (pgp public key on simple request)
Key fingerprint: FE F8 D4 63 A5 93 98 80 AC 7F 95 C1 85 6E 39 53

Browse pgsql-novice by date

  From Date Subject
Next Message ffrt 2001-06-07 15:20:11 Again: How do I select primary/foreign keys?
Previous Message Rob Arnold 2001-06-07 10:57:34 Re: Upgraded to Red Hat 7.1, now my DB is toast?