Re: Getting list of Indexes & contrains

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(at)postgresql(dot)org [mailto:pgsql-php-owner(at)postgresql(dot)org]
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