If you only want list and not exact description : Use '\di' for indexes And for sample description of a table '\d <yourtable>' But for real description you have to cross pg_* tables. Regards Alban -----Original Message----- From: pgsql-php-owner@xxxxxxxxxxxxxx [mailto:pgsql-php-owner@xxxxxxxxxxxxxx] On Behalf Of Andrei Verovski (aka MacGuru) Sent: jeudi 8 septembre 2005 22:29 To: PostgreSQL - PHP Subject: [PHP] Getting list of Indexes & contrains 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/ ************************************************ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
