Received: from mail-relay.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 82F714758F5 for ; Wed, 17 Jul 2002 11:07:00 -0400 (EDT) Received: (qmail 1739 invoked from network); 17 Jul 2002 14:58:14 -0000 Received: from system67.trade-india-local.com (192.168.0.67) by infocom-236-129-del.trade-india.com with SMTP; 17 Jul 2002 14:58:14 -0000 Content-Type: text/plain; charset="iso-8859-1" From: "Rajesh Kumar Mallah." Organization: Infocom Network Limited. To: Dirk Lutzebaeck , pgsql-sql@postgresql.org Subject: Re: How to find out if an index is unique? Date: Wed, 17 Jul 2002 20:40:28 +0530 User-Agent: KMail/1.4.1 References: <15669.16833.74916.773006@cayambe.core.aeccom.com> In-Reply-To: <15669.16833.74916.773006@cayambe.core.aeccom.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200207172040.28157.mallah@trade-india.com> X-Archive-Number: 200207/267 X-Sequence-Number: 8645 perhaps This is more elegant has Tom has indicated : select pg_get_indexdef(oid) from pg_class where relname =3D 'email_bank_ema= il'; pg_get_indexdef ---------------------------------------------------------------------------= ---- CREATE UNIQUE INDEX email_bank_email ON email_bank USING btree (lower(emai= l)) (1 row) substitue 'email_bank_email' with name of your index..... regds mallah. On Wednesday 17 July 2002 15:36, Dirk Lutzebaeck wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org --=20 Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.