Hi, I am using PostgreSQL 8 and adodb. adodb has a built-in function which scans and retrieves db structure as assotiative array. Unfortunately, it do not list indexes and constrains. What would be a SQL statement to retrieve them? Thanks in advance for any suggestion(s). ************************************************ *** with best regards *** Andrei Verovski (aka MacGuru) *** Mac, Linux, DTP, Programming Web Site *** *** http://snow.prohosting.com/guru4mac/ ************************************************