Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id A1630475BD0 for ; Wed, 17 Jul 2002 19:33:11 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id C2EDF381927; Wed, 17 Jul 2002 19:32:15 -0400 (EDT) From: "Ligia Pimentel" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: How to find out if an index is unique? Date: Wed, 17 Jul 2002 17:27:33 -0500 Organization: . Lines: 37 Message-ID: References: <15669.16833.74916.773006@cayambe.core.aeccom.com> Reply-To: "Ligia Pimentel" X-Complaints-To: news@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 To: pgsql-sql@postgresql.org X-Archive-Number: 200207/281 X-Sequence-Number: 8659 You could also use describe (in psql environment ) psql mydatabase mydatabase=# \d indexname Index "indexname" Attribute | Type ------------+--------------- fieldname | datatype unique btree The word "unique" will show up only if the index has the unique qualification, otherwise it will read only "btree". Hope this helps. Ligia "Dirk Lutzebaeck" wrote in message news:15669.16833.74916.773006@cayambe.core.aeccom.com... > > 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