Home > mailing lists

How do I SELECT primary/foreign keys? - Mailing list pgsql-novice

From	ffrt
Subject	How do I SELECT primary/foreign keys?
Date	June 7, 2001 10:31:28
Msg-id	Pine.LNX.4.33.0106071309540.22426-100000@ace Whole thread Raw
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: "Rob Arnold"
Date: 07 June 2001, 09:58:07
Subject: Re: Upgraded to Red Hat 7.1, now my DB is toast?

From: ffrt
Date: 07 June 2001, 14:30:12
Subject: Again: How do I select primary/foreign keys?

How do I SELECT primary/foreign keys? - Mailing list pgsql-novice

Previous

Next