Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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.

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

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group