Getting list of Indexes & contrains

From: "Andrei Verovski (aka MacGuru)" <andreil1(at)starlett(dot)lv>
To: pgsql-php(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Getting list of Indexes & contrains
Date: 2005-09-10 09:47:59
Message-ID: 200509101247.59877.andreil1@starlett.lv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/
************************************************

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2005-09-10 16:22:49 Re: Stupid question about triggers
Previous Message ajith kumar 2005-09-10 07:58:37 Please help