Getting list of Indexes & contrains

From: "Andrei Verovski (aka MacGuru)" <andreil1(at)starlett(dot)lv>
To: PostgreSQL - PHP <pgsql-php(at)postgresql(dot)org>
Subject: Getting list of Indexes & contrains
Date: 2005-09-08 20:28:40
Message-ID: 200509082328.40506.andreil1@starlett.lv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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

Responses

Browse pgsql-php by date

  From Date Subject
Next Message WeiShang 2005-09-10 07:48:38 commit and rollback
Previous Message Jim C. Nasby 2005-08-23 00:57:52 Re: [PHP] Data insert