Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 6B9FB475425
	for <pgsql-sql@postgresql.org>; Tue, 28 May 2002 14:47:09 -0400 (EDT)
Received: from lsh114.siteprotect.com (lsh114.siteprotect.com
 [66.113.130.247])
	by postgresql.org (Postfix) with ESMTP id 3CEC047511A
	for <pgsql-sql@postgresql.org>; Tue, 28 May 2002 14:47:08 -0400 (EDT)
Received: from bethvizx (ns2.vizxlabs.org [216.122.78.42])
	by lsh114.siteprotect.com (8.9.3/8.9.3) with ESMTP id NAA02411
	for <pgsql-sql@postgresql.org>; Tue, 28 May 2002 13:47:07 -0500
From: "Beth Gatewood" <beth@vizxlabs.com>
To: <pgsql-sql@postgresql.org>
Subject: query system tables to find columns unique constraint is
 constraining?
Date: Tue, 28 May 2002 11:47:02 -0700
Message-ID: <004a01c20678$0ee472d0$6901a8c0@bethvizx>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
Importance: Normal
X-Archive-Number: 200205/299
X-Sequence-Number: 7934



Hi-

I have been fiddling around trying to figure out which columns some unique
constraints are constraining by querying  the system tables.....with zero
luck.

Can anyone suggest how to do this?

thank!
Beth