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
