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

Thanks. I see it now.

[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> 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
>
>
>
> ************
>

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026