unique indexes

Hi,

Thankyou for your help with pg_trigger :)

I am trying to list the indexes for a table. So far I've come up with this SQL
query:

SELECT bc.relname AS TABLE_NAME,
a.attname AS COLUMN_NAME,
a.attnum as KEY_SEQ,
ic.relname as PK_NAME
FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a
WHERE bc.relkind = 'r'
 and upper(bc.relname) = upper('tablename')
 and i.indrelid = bc.oid
 and i.indexrelid = ic.oid
 and ic.oid = a.attrelid
 ORDER BY table_name, pk_name, key_seq;

I need to extend it slightly to get whether each key is unique or not. Any
ideas on how this might be done?

I would be grateful for any help.
Thanks,
Jason Davies.

=====
Jason Davies,

 _  _ _|_ _ _  _  _| _    | www.netspade.com
| |(/_ | _\|_)(_|(_|(/_   | programming tutorials
           |              | programming community
-----------------------   | programming news

__________________________________________________
Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays!
http://calendar.yahoo.com/