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 | int4
b | text
unique btree

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