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