Again: How do I select primary/foreign keys?

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

Hi again and sorry for the overhead,

it seems I didn't express myself 100% clearly. I need a SELECT statement
that will give me, for a given table (pg_class.relname='...'), the name of
the column (pg_attribute.attname) that contains the primary key (if any),
and the names of the columns that contain foreign keys.

I can't seem to get there quite yet.
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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Case 2001-06-07 16:03:23 C++ help
Previous Message ffrt 2001-06-07 11:14:17 How do I SELECT primary/foreign keys?