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@aeccom.com> wrote in message
news:15669.16833.74916.773006@cayambe.core.aeccom.com...
>
> 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