PG Index

Started by akp geekover 16 years ago2 messagesgeneral

akpgeek@gmail.com

over 16 years ago

Hi All -

Is there way to the list of indexes created for all the tables in
postgres? can you please help

Regards
Venkat

cernst@esoft.com

over 16 years ago

In reply to: akp geek (#1)

Re: PG Index

SELECT * from pg_stat_user_indexes;

Show quoted text

On 01/07/2010 02:23 PM, akp geek wrote:

Hi All -

Is there way to the list of indexes created for all the tables
in postgres? can you please help

Regards
Venkat