Received: from k3.core.aeccom.com (unknown [194.29.229.222]) by postgresql.org (Postfix) with ESMTP id CD68647585D for ; Wed, 17 Jul 2002 06:06:56 -0400 (EDT) Received: from cayambe.core.aeccom.com (cayambe.core.aeccom.com [192.168.2.12]) by k3.core.aeccom.com (8.11.6/8.11.6) with ESMTP id g6HA6vd14024; Wed, 17 Jul 2002 12:06:57 +0200 Received: (from lutzeb@localhost) by cayambe.core.aeccom.com (8.11.6/8.11.0) id g6HA6vd02519; Wed, 17 Jul 2002 12:06:57 +0200 From: Dirk Lutzebaeck MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <15669.16833.74916.773006@cayambe.core.aeccom.com> Date: Wed, 17 Jul 2002 12:06:57 +0200 To: pgsql-sql@postgresql.org Subject: How to find out if an index is unique? X-Mailer: VM 7.00 under 21.4 (patch 6) "Common Lisp" XEmacs Lucid X-Archive-Number: 200207/261 X-Sequence-Number: 8639 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