From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Beth Gatewood <beth@vizxlabs.com>
To: pgsql-sql@postgresql.org
Subject: Re: query system tables to find columns unique constraint is constraining?
Date: Tue, 28 May 2002 14:12:28 -0700
Message-ID: <03e801c2068c$5fb41260$3200a8c0@internal> (raw)
References: <004a01c20678$0ee472d0$6901a8c0@bethvizx>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chriskl@familyhealth.com.au, beth@vizxlabs.com
Subject: Re: query system tables to find columns unique constraint is constraining?
In-Reply-To: <03e801c2068c$5fb41260$3200a8c0@internal>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox