It's all in the pg_index table. Check for unique indices.
Chris
----- Original Message -----
From: "Beth Gatewood" <beth@vizxlabs.com>
To: <pgsql-sql@postgresql.org>
Sent: Tuesday, May 28, 2002 11:47 AM
Subject: [SQL] query system tables to find columns unique constraint is
constraining?
>
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
