Re: [HACKERS] Re: [PATCHES] A bag of psql goodies

On 1999-11-26, Bruce Momjian mentioned:

> Peter, is there a way from pgsql to show if an index is unique?  It
> would be nice.

Works here:
(I think this was part of the last patch.)

play=> \d baaz       Table "baaz"Attribute | Type |  Extra   
-----------+------+----------a         | int4 | not null
Index: baaz_pkey
Rule: baaz_rule

play=> \d baaz_pkey
Index "baaz_pkey"Attribute | Type 
-----------+------a         | int4
unique btree (primary key)

play=> \d bar            Table "bar"Attribute | Type | Extra 
-----------+------+-------a         | int4 | b         | text | 
Indices: barindex,        barunique
Constraints: a > 0            b IN ( 'yes' , 'no' )

play=> \d barindex
Index "barindex"Attribute | Type 
-----------+------a         | int4
btree

play=> \d barunique
Index "barunique"Attribute | Type 
-----------+------a         | int4b         | text
unique btree

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden