PostgreSQL Administration - Getting list of Indexes & contrains

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Getting list of Indexes & contrains

Andrei Verovski

2005-09-13, 3:23 am

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 2: Don't 'kill -9' the postmaster

Sponsored Links