Обсуждение: Getting list of Indexes & contrains

Поиск
Список
Период
Сортировка

Getting list of Indexes & contrains

От
"Andrei Verovski (aka MacGuru)"
Дата:
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/
************************************************