Getting list of Indexes & contrains

Hi,

I am using PostgreSQL 8 and adodb. adodb has a built-in function which=20
scans and retrieves db structure as assotiative array. Unfortunately,=20
it do not list indexes and constrains. What would be a SQL statement=20
to retrieve them?

Thanks in advance for any suggestion(s).


************************************************
*** =A0 with best regards=20
*** =A0 Andrei Verovski (aka MacGuru)
*** =A0 Mac, Linux, DTP, Programming Web Site
***
*** =A0 http://snow.prohosting.com/guru4mac/
************************************************

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster