Re: How to find out if an index is unique?

You could also use describe (in psql environment )

psql mydatabase
mydatabase=# \d indexname

Index "indexname"
Attribute | Type
------------+---------------
fieldname | datatype
unique btree

The word "unique" will show up only if the index has the unique
qualification, otherwise it will read only "btree".

Hope this helps.

Ligia

"Dirk Lutzebaeck" <lutzeb(at)aeccom(dot)com> wrote in message
news:15669(dot)16833(dot)74916(dot)773006(at)cayambe(dot)core(dot)aeccom(dot)com(dot)(dot)(dot)
>
> Hello,
>
> is there a way to ask the system tables if a given index was created
> with the unique qualification? I don't want to insert data to try.
>
> Greetings,
>
> Dirk
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org