| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Beth Gatewood" <beth(at)vizxlabs(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: query system tables to find columns unique constraint is constraining? |
| Date: | 2002-05-28 21:12:28 |
| Message-ID: | 03e801c2068c$5fb41260$3200a8c0@internal |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
It's all in the pg_index table. Check for unique indices.
Chris
----- Original Message -----
From: "Beth Gatewood" <beth(at)vizxlabs(dot)com>
To: <pgsql-sql(at)postgresql(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wei Weng | 2002-05-29 16:06:14 | Can you help with this JOIN? |
| Previous Message | Tom Lane | 2002-05-28 19:10:33 | Re: query system tables to find columns unique constraint is constraining? |