Quick Links

How to find out if an index is unique?

From:	Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	How to find out if an index is unique?
Date:	2002-07-17 10:06:57
Message-ID:	15669.16833.74916.773006@cayambe.core.aeccom.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

Hello,

is there a way to ask the system tables if a given index was created
with the unique qualification? I don't want to insert data to try.

Greetings,

Dirk

Responses

Re: How to find out if an index is unique? at 2002-07-17 10:15:07 from Achilleus Mantzios
Re: How to find out if an index is unique? at 2002-07-17 15:10:28 from Rajesh Kumar Mallah.
Re: How to find out if an index is unique? at 2002-07-17 22:27:33 from Ligia Pimentel
Re: How to find out if an index is unique? at 2002-07-18 16:22:00 from Christoph Haller

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Achilleus Mantzios	2002-07-17 10:15:07	Re: How to find out if an index is unique?
Previous Message	Richard Huxton	2002-07-17 09:29:16	Re: Indexing UNIONs