Thread: Re: [PATCHES] A bag of psql goodiesu

Peter, is there a way from pgsql to show if an index is unique?  It
would be nice.
test=# create table x(y int);CREATEtest=# create unique index xx on x(y);CREATEtest=# \d xx       Table "xx" Attribute
|Type | Info -----------+------+------ y         | int4 | 
 

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

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

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@gmx.net                   75262 Uppsala
> http://yi.org/peter-e/            Sweden
> 
> 
> 
> ************
> 


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